Forum Discussion
Error when connecting to SQL server analysis services database
I am receiving an error when attempting to load data from Analysis Services into PowerBI. The error message is:
Load
Name of datasource
Datasource.Error: AnalysisServices: The Auto Exist operat...
Thanks, I will look at that.
I don't get that error when using Excel with the same data from Analysis Services though.
John
Hi,
I'm getting the same issue when I add in an extra dimension attribute. I'm guessing its complaining about the volume of data being generated but Excel happily deals with the level of data being requested.
Could it be something to do with the SSAS connector that Power BI uses?
Is there any solutions?
Thanks