What is the recommended way to work with Azure Analysis Services cubes for PowerBI?

Question

Hi,

 

I have tried the tabular model extension for Visual studio 2022 and 2019. Both are not working well. For example, the addon for 2022 does not install at all. The extensions for 2019, come with some bugs. When I try to import our Azure Analysis services model, it gives me a compatibility error

I tried to use tabular editor (as mentioned by Microsoft) instead. But this seems to be an open source tool where you need to pay up to have the fully working version (Tabular editor 3)

What is the recommended way of working with SSAS cubes for PowerBI?

Answer 1

Hello @Øyvind Rogne ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is recommended way to work with Azure Analysis Services cubes for PowerBI, please do let us know if its not accurate.
As document says the recommeneded way is to use Visual sttudio . The compatable issues which you mentioned is set as per the SSAS version . Please do read about this here .
https://learn.microsoft.com/en-us/analysis-services/tabular-models/compatibility-level-for-tabular-models-in-analysis-services?view=sql-analysis-services-2022

Also since you are using PowerBI , I am very confident that the PowerBI desktop look here , does provide a good IDE and features , I am not sure if you have already looked into that .
https://powerbi.microsoft.com/en-us/desktop/
Please do let me if you have any queries.
Thanks
Himanshu

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators