Forum Discussion

littlemojopuppy's avatar
littlemojopuppy
Community Champion
5 years ago

Power BI Premium vs. Azure Analysis Services

Hola!  Would like to ask for some advice on something from people more knowledgeable than I.   Company is currently paying for Azure Analysis Services (S1) to house a data model that theoreticall...
Need Help
ElizabethTachji's avatar
ElizabethTachji
Helper III
5 years ago

@ElizabethTachji

Hi @ littlemojopuppy 

When you no longer use Analysis Services and only use Power BI Premium, where do you build the data models (relationships) and the DAX measure or variables.  I get connecting to a live dataset, but where does the one source of truth (DAX) reside.  

Thanks in advance.

Elizabeth Tachjian
littlemojopuppy's avatar
littlemojopuppy
Community Champion
5 years ago

Hi ElizabethTachji ...sorry for the delay in replying.  One could create a data model in a pbix file and publish that into Power BI Premium.  But that really doesn't seem like the kind of thing that would tolerate large volumes of data very well.

I was able to publish a data model from Visual Studio directly into Power BI Premium, but only if there were no security roles/members defined.  How Analysis Services handles RLS and how Power BI reports handle RLS are very different.