Request Memory Limit Issue - Live Connection SSAS

[Laurin]

Dear Community

I want to connect my SSAS Cubes to Power BI Desktop and at first it works. The issues arise when selecting data for a table or graphic. I get an error "the visualization can't be shown" and the details behind say "dbpropmsmdrequestmemorylimit property was not recognized".

Now, I was doing alot of research already and did not find the exact source of the problem. It seems that this issue is not super popular. 

1. Possible problem: My SSAS Version (2014) is not carrying the Property "QueryMemoryLimit" and therefore no data is retrieved

2. Possible problem: Data is too large and Memory Limits are exceeded

3. Possible problem: Maybe Security issues - but very unlikely as I am connected to the database

Important for you to know is that I can Direct Query all of the Tables from SQL Server without issues.

Thank you so much for your help!

[patoduck]

I'm having the same issue, connecting to Analysis Services 2014 with Power BI. 
We do not have that property in SQL 2014

DbpropMsmdRequestMemoryLimit

Overrides the server property value for a connection.

Specified in kilobytes, this property can reduce the amount of memory used during a query from the maximum allowed memory (specified as a percentage) in QueryMemoryLimit. It cannot increase the amount of memory used beyond the maximum allowed memory specified in QueryMemoryLimit.

[patoduck]

I have found the solution, quite simple just go to Power BI Options, the for current file in the Query Limit simulations, select "No query limits"

then it will just work.

The dbpropmsmdrequestmemorylimit is a new feature of SQL 2016 and later, Power BI is using this to simulate query limits, they just to forgot that earlier versions of SQL don't have that, so hopefully they can default to "No Query Limits" when they detect an earlier version.

[Laurin]

Thanks for your reply! Do you know where to specify or even add the property? I do not have it currently on my SSAS Instance....

[amitchandak]

@Laurin , This is special purpose property- check have used it; if  yes make sure it has the correct value

https://learn.microsoft.com/en-us/analysis-services/instances/connection-string-properties-analysis-...