Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

tool choice to create SSAS tabular cube - Power BI Desktop vs Visual Studio

I am trying to determine the pros and cons of what tool to use to create an SSAS tabular cube.  I am considering Power BI Desktop and Visual Studio.   For reference, to create a cube in Power BI De...
Need Help
bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

I think alot depends on the size and complexity of your model.

I generally find Power Bi is a very rapid way of starting things off. I then publish an initial version.

 

At that point I switch to Tabular Editor but VS would also work which I find easier to use for on going maintenance without having to constantly republish from Power Bi (work via XLMA end point).

I see two main advantages in that approach:

1) Easier model maintenance.

2) Tabular and VS expose model.bim which is JSON and plays nicely with GIT.