Forum Discussion
Errors while refreshing
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
2 Replies
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
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.
