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