Exam DP-500 topic 1 question 24 discussion

CORRECT ANSWER IS: CE Modify the source of each query: You need to modify the source of each query in Report2 to use Dataset1 as the data source, instead of the local dataset. This will ensure that Report2 uses the data from Dataset1, rather than the data from the local dataset. Delete all the calculated tables: Report2 contains several calculated tables that were based on the local dataset. These calculated tables will no longer be valid when using Dataset1 as the data source, so you should delete them.

You just need to remove all the queries in the PQ and delete calculated tables. You are not able to modify queries to connect Power BI Dataset. Also, when you connect to Power BI Dataset and after that go to Power Query, there is 0 queries, nothing is displayed. Plus, in the question there is no indication that we need the calculated tables and parameters, so no problem with deleting them. We just need to move to dataset1

Correct in exam perspective

I took the exam a few days ago (14/8/2023) and I passed the exam with a score of 915. My answer was: - Modify the source of each query. - Update all the parameter values

Option C: This involves updating the source of each query in Report2 to point to the shared dataset Dataset1 Option D: If Report2 has parameters that are specific to its local dataset, you should update these parameters to match the parameters of Dataset1.

I think the question has three correct answers, We need to change source this is a fact, Also PQ and calculated columns are not available in shared dataset. The connection to a Power BI dataset won't be shown in Power Query. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models also see here regarding above: https://community.fabric.microsoft.com/t5/Desktop/Can-not-use-Power-Query-with-a-shared-dataset/td-p/2090909 While you're using Power Bi Shared dataset, you can create measures but you will not be able to create a new column or do any such changes in your report as it derives it's properties and data from the source dataset. https://community.fabric.microsoft.com/t5/Service/Help-needed-with-shared-datasets-and-limitations-of-live/m-p/2386845#:~:text=While%20you're%20using%20Power,data%20from%20the%20source%20dataset. Same thing here: video time 6:35 https://radacad.com/power-bi-licensing-walk-through-guide

How can you connect to the new data sources without modifying the existing sources

You connect to a shared dataset using a live connection. Therefore you can not use PQ.

You can modify the source for each query and the calculated tables are automatically updated if the underlying source is changed provided the structure is still the same in the new data source.

C and D are correct

C and D are OK

The correct answers are C and D. Explanation: To prepare Report2 to use Dataset1, you need to modify the queries' source to point to Dataset1 and update the parameter values accordingly. Therefore, you should perform the following actions: C. Modify the source of each query: You need to update the source of each query in Report2 to point to Dataset1 instead of the local dataset. To do this, open Power Query Editor in Report2, select each query, and then update the data source to use Dataset1. D. Update all the parameter values: If Report2 contains any parameters, you need to update their values to match the parameters in Report1 that connect to Dataset1. To do this, go to the "Manage Parameters" dialog box in Report2 and update the parameter values to match those in Report1.

Answer is CORRECT (C& D) You need to prepare Report2 to use Dataset1. It never says you need to make Report 1 to be the same as Report1. You do not need to delete the calculated tables or parameters, you just need to update the values.

I would go for B and E based on this blog: https://technologyblog.rsmus.com/data-analytics/power-bi-datasets-changing-your-data-source/

I choose AC

BE, If you connect to a Power BI dataset, you cannot connect other sources at the same time. To connect a Power BI dataset, you must first remove all existing connections in Power Query and Calculated Table & Measure