Forum Discussion

Anonymous

Not applicable

10 years ago

Solved

Importing in from SSAS Cube

I'm having trouble importing from an SSAS cube. It just gets stuck at the "Evaluating" stage and nothing ever happens. Any ideas?

cwebb
10 years ago
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:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11331360-connect-multidimensional-to-sql-server-standard-li

Sorry...

Chris
cwebb
10 years ago
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

Anonymous

Not applicable

10 years ago

cwebb This is a cross post from this thread. It still isn't a supported feature to my knowledge.

Advocate V

10 years ago

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

Related content