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,
We are providing a SaaS system and let our customers analyze their data in Power BI Service (not embedded) using reports we builded for them.
The system database is Azure SQL.
We considered building an Azure Tabular Model to serve for a unified model for all reports and all customers. The main drivers are implementing a permission model (RLS-like), reducing model maintenance, supporting DirectQuery and preparation for embedding reports in the SaaS system.
Lately we heared about XMLA endpoint and that it's actually a Tabular model. Does XMLA support all the driving requirements? I'm worried mainly for permissions, direct query and storage.
Thanks,
Barak
Solved! Go to Solution.
Have a read of
https://powerbi.microsoft.com/en-us/blog/power-bi-as-a-superset-of-azure-analysis-services/
My understanding is that power bi premium will eventually offer everything that azure analysis service has and more.
Have a read of
https://powerbi.microsoft.com/en-us/blog/power-bi-as-a-superset-of-azure-analysis-services/
My understanding is that power bi premium will eventually offer everything that azure analysis service has and more.
You could test for your specific use cases by purchasing a couple of power bills premium per user licences. (Eg no need to go for full capacity purchase)
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.