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
It actually says is set to true. I looked again and it's not all of my measures. There is one that is a percentage that comes over as text. There might be a percentage sign in there that's throwing it off, I'll check. Also, as to the above about not being able to connect live, The user does appear to have the correct SSAS version installed. Any other ideas as to why it won't do a direct connect
Maybe you could try (re)installing the latest version of the OLEDB for OLAP provider? You can get it here:
https://www.microsoft.com/en-us/download/details.aspx?id=52676
Regards,
Chris