Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
barakb321
Frequent Visitor

Azure Tabular Model vs. XMLA vs. Data Flows

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 

1 ACCEPTED SOLUTION
bcdobbs
Super User
Super User

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

2 REPLIES 2
bcdobbs
Super User
Super User

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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)



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors