<< Prev Question

Question 31/31

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (31q)
Question 1: Case Study 2 - Contoso Ltd Overview Existing Environment Con...
Question 2: You create a dashboard that displays the results of a custom...
Question 3: You have multiple dashboards. You need to ensure that when u...
Question 4: Your company has a security policy stating that proprietary ...
Question 5: Note: This question is part of a series of questions that pr...
Question 6: You create a dashboard by using the Microsoft Power Bl Servi...
Question 7: You have the visual shown in the Original exhibit. (Click th...
1 commentQuestion 8: Drag and Drop Question You have a Microsoft Power Bl workspa...
Question 9: You have a report that contains three pages. One of the page...
Question 10: Note: This question is part of a series of questions that pr...
Question 11: Hotspot Question You need to create a visual as shown in the...
Question 12: Drag and Drop Question You build a report about warehouse in...
1 commentQuestion 13: Hotspot Question You are creating an analytics report that w...
Question 14: You build a report to help the sales team understand its per...
Question 15: You have the visual shown in the exhibit. (Click the Exhibit...
1 commentQuestion 16: Hotspot Question You have a report page that contains the vi...
2 commentQuestion 17: You have the following table named Location. (Exhibit) The G...
Question 18: You create the following step by using Power Query Editor. =...
Question 19: You are creating a visual to show the ranking of product cat...
1 commentQuestion 20: Note: This question is part of a series of questions that us...
1 commentQuestion 21: You have a collection of reports for the HR department of yo...
Question 22: You have a Power BI model for sales data. You create a measu...
Question 23: Note: This question is part of a series of questions that us...
Question 24: Hotspot Question You are creating a Microsoft Power Bl impor...
Question 25: You have a table in Power BI Desktop as shown in the followi...
Question 26: Case Study 2 - Contoso Ltd Overview Existing Environment Con...
Question 27: You have a table that contains sales data and approximately ...
Question 28: You are creating a visual to show the ranking of product cat...
Question 29: You have a report that contains four pages. Each page contai...
1 commentQuestion 30: Case Study 1 - Litware, Inc. Overview Litware, Inc. is an on...
Question 31: Note: This question is part of a series of questions that pr...