Forum Discussion

Laurin's avatar
Laurin
Regular Visitor
3 years ago

Request Memory Limit Issue - Live Connection SSAS

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 s...
Need Help
patoduck's avatar
patoduck
Helper III
2 years ago

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's avatar
patoduck
Helper III
2 years ago

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.