Forum Discussion
Importing in from SSAS Cube
It is the case that Power BI can only connect to SSAS Multidimensional Enterprise Edition (or BI Edition, though that has gone in SQL Server 2016):
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/
You can vote to try to have that changed here:
Sorry...
Chris
I've just had a second confirmation from Microsoft that DAX queries are supported in SSAS 2016 Multidimensional Standard Edition, and someone I know has tested Power BI Desktop with the same configuration and he says it works (though I haven't tested it myself). Are you sure you're using the latest version of everything?
Regards,
Chris
cwebb I'm very afraid the problem maybe the SQL is a standard edition, and it Power BI may require an Enterprise version. Really hope that's not the case as it really de-values Power BI for SSAS cube connections.
It is the case that Power BI can only connect to SSAS Multidimensional Enterprise Edition (or BI Edition, though that has gone in SQL Server 2016):
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/
You can vote to try to have that changed here:
Sorry...
Chris
That's too bad. That takes away a huge part of the appeal. A Microsoft forum probably isn't the best place to ask, but are you aware of any other front end reporting tools that can accomplish this?
Actually, I've just found out that you can use Power BI with SSAS 2016 Multidimensional Standard Edition too.
Are you asking about other front end tools for Analysis Services? There are still a few left out there: Pyramid Analytics, XLCubed, Panorama Necto and Targit.
Chris
cwebb We just installed 2016 SQL Standard and it's not allowing a live connection.
Hmm, I was specifically told by someone senior at Microsoft that this would work. I'll ask again and get back to you. Are you using the very latest version of Power BI Desktop?
Chris
I've just had a second confirmation from Microsoft that DAX queries are supported in SSAS 2016 Multidimensional Standard Edition, and someone I know has tested Power BI Desktop with the same configuration and he says it works (though I haven't tested it myself). Are you sure you're using the latest version of everything?
Regards,
Chris
Got it working now. The only issue I'm having now is we changed the name of the cube and the pbix desktop files that had the live connection won't let me in. The server name is the same, but there's not a place to put in the new cube database name. I don't know a way to change that, so I'll have to start all over.
This is marked as solved????
This was about not being able to import large cubes into Power BI.
There are no solutions in this thread.
What exactly are the limitations of power bi on size, cube or otherwise?
