Errors while refreshing

[lk94]

Hello,

I created a reporting in PowerBI. The Data-Basis are Excel-Files, i get from a sharepoint. Until yesterday it all worked fine, without any errors.

Today I got several errors while trying to refresh the data:

Things I already checked/tried:

1) The table "zk_proddat_list", which cannot be found by powerbi still exists where it should be

2) there is no duplicate value in ZPTT3

3) I tried to refresh in an older version of the report, but got the same errors

4) I checked the files on the sharepoint, all seems correctly

Can you maybe help which else i could try to solve the errors and finally be able to refresh the data again?

Thanks in advance, best regards

[Anonymous]

Hi @lk94 ,

Did you make any update on this sharepoint excel file recently? Could you please create a new file to connect this excel file and check whether you can connect it successfully? And please try the suggestions from @amitchandak to clear cache and permission, you can find the details as follow:

1. Clear cache

• File –> Options –> Data Load –> Data Cache Management Options, click “Clear Cache” then click “OK”)

• Exit Power BI desktop and restart it

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[amitchandak]

@lk94 , clear permission, and cache and try again.

Also, refer support page for know issue on Nov 2020 and their solution - https://powerbi.microsoft.com/en-us/support/

if does not resolve with the above 2, check and log an issue at https://community.powerbi.com/t5/Issues/idb-p/Issues