Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear all!
Part of the new features in Excel, we now have the ability to create directly from Excel a pivot table from our datasets on PBI platform.
Is there a way to manage access to that feature ?
Actually, the users do not currently have access to the Analyze in Excel function in our current situation. We want to control the way the data is going to be used and expanded, so, even if we love the ability to connect directly to PBI from Excel, we would like to control it.
The only option I saw so far was to remove the function in the Excel ribbon, but I guess I need to be admin on my comptuer to change that.
Is there another way ?
PY
Hi @Anonymous ,
The Excel Data Types Gallery and connected experiences to Power BI featured tables is only available for Excel E5 and G5 customers. And Excel only displays featured tables that are stored in the new Power BI workspaces, you need to have permission to access this. You could refer to service-excel-featured-tables for requirements and limits.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dax,
Thanks for the feedback!
Actually, even if users have access to the datasets, I would like to restrict the function from Excel
So, far I could remove from the ribbon the whole function to create a pivot table (what I don't want to do),.
Is there another option ?
PY