Forum Discussion

sasopotocnik's avatar
sasopotocnik
New Member
4 years ago

Get data from SSAS cube in hybrid mode

Hello,   We have a report created in PowerBI Desktop RS with datasource being a transactional database (GetData with sql queries). We wan't to add additional data by quering a cube from SSAS. But w...
Need Help
Alexrai's avatar
Alexrai
Icon for Helper I rankHelper I
4 years ago

Microsoft says only enterprise 2014+ supports live connections. https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-ssas-multidimensional

 

I found that SSAS Multi-Dimensional was clunky in PowerBI. Instead of importing I just truncate/rebuild the dimensions with 3 years of fact tables in SSIS every evening, and use PowerQuery for some minor import editing. It's the identical tables that feed SSAS Multidimensional star schema, but served from temporary tables on SQL Server instead. I would use tabular but we only have 2012 standard edition.

 

If you have 2014+ standard you should be able to use tabular model, that would be (in my opinion) a better choice if you have one.