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.
Hi Everyone,
Anyone getting this error while loading data from SQL and Excel file. Kindly reply with solution.
I have already checked below things -
"failed to save modifications to the server. error returned there's not enough memory to complete this operation"
Regards,
Aditya Vighne
Hi @adityavighne,
The error can be caused by the dataset hit the limitation, if you are using Import mode, the .pbix file in service shouldn't more than 1G. See: File size limit increase to 1 GB . If it's DirectQuery, there is a 1 million row limit for returning data. See: Limitations of DirectQuery.
Please try to filter on query to limit less data returned, then republish the report to service and refresh to see if the issue occurs.
Regards,
Frank
Hi v-frfei-msft,
Thanks for reply.
File size is not more than 1GB or 1million row.
filters on query are present already.
Also I checked with MS Power BI support team they are not sure about this error.
Thansk & REgards,
Aditya Vighne
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |