Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I am looking on a clear answer for removing the "Analyze in Excel" feature that we can see when using a Power BI Report via using the (...) menu top right.
I have found the below post, but it mentions in the Tenant settings: "Allow users to use Analyze in Excel with on-premises datasets"
https://community.powerbi.com/t5/Service/Disable-Analyse-in-Excel/td-p/74106
So just to clarify, will a SQL Server with SSAS/SSIS/SSRS as a VM hosted in Azure is considered as "on-premises dataset"?
And if so, will the above mentioned tenant setting work to remove the access?
Thanks
Regards
Solved! Go to Solution.
HI @Fabiann ,
>>So just to clarify, will a SQL Server with SSAS/SSIS/SSRS as a VM hosted in Azure is considered as "on-premises dataset"?
It means you installed sql server database in a virtual device who host on cloud, it also included in on-premise datasource.
>>And if so, will the above mentioned tenant setting work to remove the access?
It only means 'analysis in excel' requests has been block, it not affect other operations on your vm.
Regards,
Xiaoxin Sheng
HI @Fabiann ,
>>So just to clarify, will a SQL Server with SSAS/SSIS/SSRS as a VM hosted in Azure is considered as "on-premises dataset"?
It means you installed sql server database in a virtual device who host on cloud, it also included in on-premise datasource.
>>And if so, will the above mentioned tenant setting work to remove the access?
It only means 'analysis in excel' requests has been block, it not affect other operations on your vm.
Regards,
Xiaoxin Sheng
Ok you confirmed that a SQL Server DB in a VM on Cloud is considered a on-premises dataset - Thanks
Yes this is what I meant, by setting up Admin Portal/Tenant Settings/ "Allow users to use Analyze in Excel with on-premise datasets" to No, this will remove the "Analyze in Excel" option from Power BI Reports.
Am I correct?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.