Sharepoint data set does not refresh

[Anonymous]

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

[TeigeGao]

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

[Anonymous]

Hi,

The dashboard can refresh but if i modified in edit querys the problem persist, I think it happens when something changes.

Regards