Forum Discussion
Query error: Working storage is limited
Hello community,
when I edit queries in PowerBI Desktop and increase my data volume I receive the following error "Data.Source.Error:AnalysisServices - Your working space is limited". I have 32 GB in memory and only 4,5 GB in usage and definitely enough working space.
Under options at PowerBI desktop I have seen that the standard limitation is 4096 MB and changed it to 20 GB, but it has no effect. Do you have any recommendations?
4 Replies
Borntoreport From the error it seems you are trying to connect with Analysis Services OLAP or Tabular models. If yes, then why you are importing the data? you can connect directly with SSAS in Live mode.
HarrisMalik Good point! So far I have always imported my data. After your comment I have tried to change from import to live connection, but it does not work. For the moment it is fine for me to import. It always works until 4 to 4,5 GB, but when I try to upload more data I receive the error.
Borntoreport what is the problem/error/issue when you try to connect SSAS in live mode?
