Forum Discussion

littlemojopuppy's avatar
littlemojopuppy
Icon for Community Champion rankCommunity 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
Icon for Helper III rankHelper 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
Icon for Community Champion rankCommunity Champion
5 years ago

ElizabethTachji I realized I didn't completely answer your question.

 

You can develop the data model in one of three ways:

  • In a pbix file just like any other data model and publish to a workspace.  Probably not the best idea for a large volume of data, either in terms of number of tables or records
  • In Visual Studio using the add-in for Analysis Services Tabular data models.  Substitute the Power BI Premium XMLA endpoint instead of a server name/address.  Send me a PM and I'm happy to help walk through steps.  You cannot have any security defined using this method.  All security has to be defined in the reports themselves..
  • You could probably use Tabular Editor as well but I haven't tried this.  Same restrictions on security.

The second method is better because you can handle a much larger set of data in a much more controlled way.  UNLESS you have a lot of security requirements because Power BI Premium only supports RLS defined at the report level and not in the data source itself.

 

This isn't ideal, but it seems that's the way it is.