When Refresh error - how to know which file name from which folder PBI unable to read

[admin11]

Hi All,

yesterday i got very important hints from @TheoC  when we encounter error msg while refresh data from below post.

https://community.powerbi.com/t5/Desktop/In-what-situation-can-cause-PBI-refresh-error/td-p/2366269

Hope some one can share some link , so that i can find out in detail where i can locate the file ? The issue share point folder i created only i am able to access , as i never share those file with other user. ( no other user can access ) , unless i accident delete some file.

Paul Yeo

[V-lianl-msft]

Hi @admin11 ,

Please click the file->Options and Settings->Data Source Settings, you will get the following data source settings navigator.

Here you can see the location of the data source of this pbix connection

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11 · Accepted solution]

@V-lianl-msft @VahidDM 

https://community.powerbi.com/t5/Desktop/My-PBI-unable-refresh-what-else-I-should-try/m-p/2376958#M8...

Finally i manage to find a way to solve the issue , see the above post. now i know that PQ editor is very useful.

Paul

[admin11]

@V-lianl-msft @VahidDM 

Thank you very much for your advise , which is very helpful , Hope you can help me look into below post , which is related :-

https://community.powerbi.com/t5/Desktop/How-to-globally-set-permission-for-access-sharepoint-folder...

Paul

[VahidDM]

Hi @admin11 

If you remove some file and those files are connected to your PBI report, you can not refresh your PBIX file and will face with issue but if you imported the data before removing those files, you still can use those data without refreshing or copy and past those data to create those removed files.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[admin11]

@VahidDM 

Thank you for sharing.

i cannot understand below msg , kindly say again :- 

but if you imported the data before removing those files, you still can use those data without refreshing or copy and past those data to create those removed files.

[VahidDM]

@admin11 

If you have updated the PBIX file and imported data to it before removing the file, then those files' data are still in your PBI file, and you can use them before updating that.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/