Forum Discussion
akj2784
Post Partisan
Post PartisanDo we need Sql Server Developer tools SSDT for SSAS ?
Hi All, We are planning to have Sql Server Analysis Services 2017 for Power BI Desktop. Just wanted to check do we need Sql Server Developer Tools as well ? And what is the purpose of that. Cou...
v-sihou-msft
Microsoft Employee
Microsoft Employee
Power BI Desktop is more like a reporting tool (Report Builder + Power Query Editor). It can handle Analysis Services Tabular project, but it can't work with Multidimensional project.
When connecting SSAS, I suggest always open live connection since it will load entire model. Otherwise, it will just import flat table. And for SSAS source live connection, Power BI directly takes role security you configured in Tabular/Multidimensional Cube.
Regards,
akj2784Post Partisan
Post PartisanThank you for reply.
When you say Live connection, do you mean creating a model in Power BI Desktop by selecting DirectQuery and connecting to SSAS. With this everytime I run a report it will hit the SSAS.
And when I publish it to Service, it will connect to SSAS via On Premise Gateway ?