In what situation can cause PBI refresh error ?

[admin11]

Hi All

I have make below post few day ago @amitchandak  have reponse to my post.

https://community.powerbi.com/t5/Desktop/Suddenly-today-i-am-unable-to-refresh-my-data/td-p/2364704

I like to confirm belowing :-

1) I get refresh error after i load one more new table from sharepoint.
2) if it is due to point (1) issue , why when i load PBI file i created during last month ,now i also get refresh error ?
3) If i change the location refresh , meaning i refresh at office and home , will i get error msg ?

What other issue can cause the refresh error ?

I have experience in the past when i transfer my PBI file to another PC , i am will get refresh error , so i need to go to data source , edit premission. it work fine.

May i know my above issue , it is also cause by edit premission issue ?

Paul Yeo

[TheoC · Accepted solution]

Hi @admin11 

It can be for many reasons but I come across a lot of issues being cause by the following:

1. The data source file(s) location has changed (e.g. someone changed a folder name). 
2. The data source file(s) has been moved (e.g. someone moved one of the source files).
3. The data source file name has been changed (e.g. someone changed the name of the file).
4. The data source file(s) has changed format (e.g. someone has used CSV instead of XLSX).

Other considerations include permissions may have changed and more infrequent issues in my experience.

All the best.

Theo 🙂

[admin11]

@TheoC 

Thank you very much for your reply. i accident click problem solve.

I believe may be due to accidently i have remove one of the file from sharepoint. 

So can i say PBI will not give us error msg indicate which file or folder from sharepoint have remove or rename ? i mean it there any way i can find out ? now i am stuck since i am unable to refresh.

Paul

[TheoC]

@admin11 the if you go into your PBIX file and hit refresh (or in Power BI Service), when you hit refresh, the error should tell you which file is missing.  I recommend doing it in Power BI Desktop and saving a version of your Power BI Desktop (PBIX file) before refreshing.  This way, you don't refresh the Power BI Service report and lose it.  If you do it in Power BI Desktop under a new saved file, you minimise the risk of further and unnecessary damage (hope that makes sense).

Theo 🙂

[admin11]

@TheoC 

Thank you again for your support. 

I have try to refresh , the error msg came out :-

When i try to scroll down to below :-

It is mean that the last row is having problem ? Does it mean that i should delete away the _Pnl_Var , and refresh again , if error again , i should delete 2nd last row table INVC_I right , till no more error right ?

Paul