Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hello,
I have a Power BI report whose data source is an Access hosted on a sharepoint.
The report consists of 11 tables, of which most do not exceed 200 records, except 1 that has 200k.
When I try to update the report via Desktop, the report stays in "evaluated" hours.
After a few minutes, the PC starts to lose performance.
As we can see there are several calls to container data, which surprised me, I started looking for the cointainer data folder, and saw that it is where power bi saves the temporary data set of the sharepoint access. From my point of view these temporary copies are not made correctly, because I have downloaded the access of my sharepoint 177 times, occupying 57GB.
This is causing my report not to update?
How is this possible?
Is there any configuration that is wrong?
Any help is welcome, thank you very much
a greeting
Hi @Anonymous ,
Firstly, please confirm that you have upgrated PowerBI desktop to the latest version, I had met a similar problem in some early verion, but I haven't met this probelm for a long time.
Then, we can unselect the "Autodetect new relationships after data is loaded" and "Import relationships from data sources" option in File -> Options and Settings -> Options -> Data Load.
Another workaround is canceling the process, because the process is in the "evaluated", the data has been imported into dataset, then we can go to PowerQuery(edit queries), we will see a warning, then click the warning and select retry.
Best Regards,
Teige
Hi,
The dashboard can refresh but if i modified in edit querys the problem persist, I think it happens when something changes.
Regards
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 57 | |
| 53 | |
| 42 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 112 | |
| 106 | |
| 39 | |
| 36 | |
| 27 |