For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.
The data model contains several measures.
You need to create a Power BI report from the existing data. The solution must minimize development effort.
Which type of data source should you use?
B
Connect to a SharePoint folder from Power Query Desktop
To connect to a SharePoint folder:
1. From Get Data, select SharePoint folder.
2. Paste the SharePoint site URL you copied in Determine the site URL to the Site URL text box in the SharePoint folder dialog box. In this example, the site URL is https://contoso.sharepoint.com/marketing/data. If the site URL you enter is invalid, a warning icon. warning icon will appear next to the URL text box.
Select OK to continue.
3. If this is the first time you've visited this site address, select the appropriate authentication method. Enter your credentials and choose which level to apply these settings to. Then select Connect.
4. When you select the SharePoint folder you want to use, the file information about all of the files in that SharePoint folder are displayed. In addition, file information about any files in any subfolders is also displayed.
5. Etc.
Reference:
https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder
It should be dataset, because the case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder.
After reading the question multiple times, the biggest takeaway is that its asking directly for data. A SharePoint folder HOLDS data, but it is not data itself. I agree with this and think its the existing dataset
The question is confusing because it doesn't tell clearly that there are two reports. So the second report can reuse the dataset of the first one.
Yea, I think so.
I think the question is clear: Publish the first report, and then create the second report from dataset of the first report
The question also implies that there is a report already created, so using the PBI dataset will include the calculated metrics
can you provide documentation/reference links on this please?
if I buy the Contributor version, does it has the correct answers?
no, with contributer access, you only have access to all the questions and can avoid captcha ... but apart from that it's the same
Does it have more than 250 questions in contributor access?
The answer is Sharepoint folder. The data model was for the previously published PowerBi report. Creating a new report from existing data refers to all Sales data on the sharepoint folder.
reuse the existing dataset.
The question is: "Which type of data source should you use?" The Power BI dataset is NOT a data source. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources Thus, since it should have minimal developing impact, it should be answer B "Sharepoint folder".
Power BI dataset is litteraly the 2nd option of your link. Answer is A
979/1000 This Question on Exam Today 13Jun24
28-Mar-24 - This Q came up. Blitzed all 266 Q's on Exam Topics and Scored 813/1000. Only 1 question out of the 50 wasn't on the test.
The first two sentences were meant to confuse you. The actual question is which "data source"
A is the answer: I am not convinced with B, the published dataset is already connected to the existing data, and to minimize effort of modeling and creating all the measures you will just reuse everything
Dataset included calculated tables, while a data flow is a collection of tables.
Sharepoint
Hi , im preparing for the 'Microsoft Certified: Power BI Data Analyst Associate' cirt. Ive completed all modules that were on the Syllabus twice and there was no mention of the dataverse. I can see its Power app module thats not on the syllabus...does anyone have a comprehensive of all modules required?
Answer is B. Even though there was a published page before, they are trying to create a NEW report which you have to use the sharepoint folder url to get access to the files. lol
The solution must minimize development effort.
Agree with Nomios! Answer I am going with: Existing Dataset bc the qs clearly states that the report is already published and the data model of that published report contains measures. Therefore, to be able to use those measures in the already published dataset, use: Existing dataset)
The correct answer should be Dataset. A connection with the Share folder was initiated for the first report. After publishing the report a Power BI dataset was created and by connecting with it we minimize the development.
I agree. the correct answer should be Dataset, as it refers to create a new PBI based on data (and a dataset) already built
a sharepoint folder
correct