Exam PL-300 topic 3 question 70 discussion

you have to have at least build permissions on the dataset https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-power-bi-datasets-excel

To enable the finance team to use Microsoft Excel to analyze the Finance dataset, you need to provide them with an Excel workbook that is connected to the dataset. This can be done by installing the Power BI publisher for Excel add-in, connecting to the Finance dataset, and then importing the data into Excel. Once the data is in Excel, the finance team can use all of Excel's analytical capabilities to analyze and visualize the data. Granting build permissions (A) or write permissions (D) to the Finance dataset would allow the finance team to modify the dataset, which is not necessary for their analysis needs. Creating a row-level security (RLS) role and adding the finance team as members (C) would only be necessary if you needed to restrict access to specific rows of data in the Finance dataset based on user roles or permissions.

Build Allows user to build new content from the semantic model and find content that uses the semantic model. Allows user to access reports that access composite models on Power BI Pro workspaces. Allows user to build composite models. Allows user to pull the data into Analyze in Excel. Allows querying using external APIs such as XMLA. Allows user to see hidden data fields. https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-permissions

In the URL shared by Maverick7513 is perfectly explained. Several prerequisites to connect PBI Semntic Models (former dataset) to excel: live connection tenant setting must be enabled, SMLA endpoints and Analyze in Excel with on-premises datasets tenant setting to be enabled…... …but the most important prerequisite for this scenario is "you must have Build permission to the PBI Semantic model ot have at least Contributor role in PBI workspace containing te Semantic Model. It has some sense a workspace has limited access, the dataset has also some security settings… you cannot bypass all these restrictions just by sharing an excel workbook connected to the dataset, it would be a back door to your data model

The finance team is not part of any role in any workspace so I believe the correct answer is B.

you build a report having a table showing every single rows and columns, you publish it in your workspace, you let users export data with current layout and they have a copy in their local.

Still a little torn between answers. Co pilot says build permission should work but you also need to have a workspace role to access the dataset. And you can do a lot more than analyze in Excel. Also you still need to enable the option in the admin settings. Giving them an Excel workbook connected to the dataset gives them ONLY the option analyse the dataset in Excel and even refresh the data. So I'm leaning to B.

AA is the correct one

Still unsure whether its A or B, and seems like the comments here are split between these two as well.

B. Provide an Excel workbook that is connected to the Finance dataset. By providing an Excel workbook connected to the Finance dataset, the finance team can use Microsoft Excel to analyze the dataset without needing to be members of any Power BI workspace roles. This approach allows them to leverage the data in the Finance dataset directly in Excel. Granting the finance team build permissions to the Finance dataset (Option A) would allow them to create reports and dashboards directly within Power BI using the Finance dataset. However, since the requirement specifically mentions using Microsoft Excel for analysis, providing an Excel workbook connected to the dataset (Option B) seems to be the more suitable solution. Option A might be a valid choice if the finance team needs to create Power BI reports, but for Excel analysis, Option B is more appropriate.

A is correct

B looks the closest answer.

https://learn.microsoft.com/en-us/training/modules/create-manage-workspaces-power-bi/2-distribute-report-dashboard?ns-enrollment-type=learningpath&ns-enrollment-id=learn-bizapps.manage-workspaces-datasets-power-bi

The finance team would need to be a member of the Power BI workspace containing the Finance dataset in order to access the dataset from Excel. The question mentions that the finance team is not currently a member of any Power BI workspace roles, which means they do not have any access to the workspace or the datasets within it. However, it's important to note that in order to connect to the dataset from Excel, the user must also have the appropriate permissions to the dataset itself. This can be achieved either by being a member of a workspace role with appropriate permissions to the dataset or having Build permissions to the dataset directly. So, to summarize, the finance team needs to be a member of the Power BI workspace containing the Finance dataset and have appropriate permissions to the dataset itself in order to connect to it from Excel

Can someone clarify if the correct answer is B or C ?

B is the correct one.

So, we consider than C is the correct one?