Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@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?
@HarrisMalik: Sorry for my late response. I can not upload the screenshot of the error, but it says "Unexpected error - the model scheme was unable to load". I have made a tracking of this error and sent it to the Power BI support. Thank you for your help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |