Forum Discussion
Build permission undelying authorizations
Hello
I would like my users to be able to use "Analyze in Excel" to explore datasets, so I need to grant them "Build" permission on the datasets. However, I do not wish them to create new reports, which Build permission also allows them to do. Is there a way to do that?
Many thanks
Hi fduperier ,
As far as I know, this cannot be done. According to the official Microsoft article description, Analyze in Excel prerequisites are below:
- Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later.
- Excel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures. Read about creating measures.
- Some organizations may have Group Policy rules that prevent installing the required Analyze in Excel updates to Excel. If you’re unable to install the updates, check with your administrator.
- Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license. To learn more about the differences in functionality between license types, take a look at the Power BI features comparison section of Power BI pricing.
- Users can connect to datasets through Analyze in Excel if they have permission for the underlying dataset. A user could have this permission in a few ways, such as having the Member role in the workspace containing the dataset, or having Build permission for a dataset in a workspace or in an app that contains the dataset. Read more about Build permission for datasets.
- Guest users can't use Analyze in Excel for datasets sent from (originating from) another tenant.
- Analyze in Excel is a Power BI service feature, and isn't available in Power BI Report Server or Power BI Embedded.
- Analyze in Excel is only supported on computers running Microsoft Windows.
Member role and Build permission for a dataset will have permission to create a new report ,I test it ,except remove the permission or change role ,I could find other ways to disable user to create new report.
Wish it is helpful for you!
Best Regards
Lucien
1 Reply
Hi fduperier ,
As far as I know, this cannot be done. According to the official Microsoft article description, Analyze in Excel prerequisites are below:
- Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later.
- Excel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures. Read about creating measures.
- Some organizations may have Group Policy rules that prevent installing the required Analyze in Excel updates to Excel. If you’re unable to install the updates, check with your administrator.
- Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license. To learn more about the differences in functionality between license types, take a look at the Power BI features comparison section of Power BI pricing.
- Users can connect to datasets through Analyze in Excel if they have permission for the underlying dataset. A user could have this permission in a few ways, such as having the Member role in the workspace containing the dataset, or having Build permission for a dataset in a workspace or in an app that contains the dataset. Read more about Build permission for datasets.
- Guest users can't use Analyze in Excel for datasets sent from (originating from) another tenant.
- Analyze in Excel is a Power BI service feature, and isn't available in Power BI Report Server or Power BI Embedded.
- Analyze in Excel is only supported on computers running Microsoft Windows.
Member role and Build permission for a dataset will have permission to create a new report ,I test it ,except remove the permission or change role ,I could find other ways to disable user to create new report.
Wish it is helpful for you!
Best Regards
Lucien