Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Azure Analysis Server to PowerBI data store

Hi Team,   I have below set up for my Power BI reports.   All the reports have live connection to cubes present in Azure Analysis server. Cube data is refreshed from Azure SQl Database tables. No...
Need Help
Show and Tell
GilbertQ's avatar
GilbertQ
Super User
5 years ago

Hi Anonymous 

 

Further to AbhiSSRS comments, this can be done.

 

You can only deploy to the XMLA Endpoint if you are using PBI Premium or Premium Per user

 

Otherwise you could create a new PBIX file and then copy across all the measures and tables using Tabular Editor.

 

Also make sure that if you are using Power bI Pro that your PBIX file size does not exceed the 1GB limitations for Pro.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks @AbhiSSRS &  GilbertQ

 for those details.

 

I have one more query how do i implement RLS in the new PBI report set up.

 

Right now all the existing PBI reports are accessed through embedded application and User Login Id is passed as a filter to Tabular cube.

 

 

How do i implement the same if i deploy datamodel & report in PBI datastore.

 

Please let me know what would be best approach .