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
I'm trying to figure out how to use an SSAS based excel report on Powerbi.com.
There has to be a way to connect an SSAS connected Power Pivot file to Powerbi.com so that it refreshes and funtions properly.
I'd like to use the charts I have from Excel in Powerbi.com.
Any tips?
To be clear, you are using Power Pivot to import data from SSAS into Excel, then uploading that workbook to Power BI? As far as I know, this should work. I guess you've seen these pages, and the links to the troubleshooting tips?
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-excel-file-onedrive/
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-excel-workbook-files/
Chris
No - that thread is about an Excel PivotTable connected direct to SSAS, but the question here is about refreshing a Power Pivot model using SSAS as a data source which I think should work. But I asked for clarification on the details just to be sure.
Chris
cwebb Thank you for the reply. I'll check on the version the user has. I've had another odd occurence with importing, my measures are coming over as text fields. Is there any way to fix that?