Forum Discussion
Error on PowerBI desktop during import procedure from sql server analysis service
Hi, on PowerBi Desktop I'm trying to import all data from Microsoft Adventure Works DWH deployed on Sql Server Analysis Service Standard Edition. If I select all measures and dimensions, during the ...
Agennaretti If you are getting all dimensions and measures, it seems like what you want is to live connect to that Cube. Can you give that a try?
I don't want to live connect to that cube but I want to import all (live connect is not supported because I have Sql Server Standard Edition).
Anyway why I receive these errors?
Hi Agennaretti,
Currently, only Enterprise and Business Intelligence editions of SQL Server are supported for MD connectivity. Please see "Limitations of SSAS Multidimensional Models in Power BI Desktop" in below link:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/
Regards,
