Forum Discussion

nenedeloscojone's avatar
nenedeloscojone
Frequent Visitor
2 years ago

Power BI fails to refresh data from Excel files in hidden folder on network

Hi Community,   I am having an issue with an odd problem, and I am hoping having someone here look at it may have an idea as to why I am having the issue.   I have report which pulls data from 4 ...
Need Help
nenedeloscojone's avatar
nenedeloscojone
Frequent Visitor
2 years ago

Hi there,

Thank you for replying to my post! Much appreciated.

 

Power BI says it can not display the errors:

 

Anything else I can try?

lbendlin's avatar
lbendlin
Super User
2 years ago

Do these users have Power BI Desktop perchance?  Can they try to load the Excel files?

 

Do their locale/culture settings differ from yours?

 

Given the large number of errors you should be able to see these too - Do a column profiling based on entire dataset

 

 

  • nenedeloscojone's avatar
    nenedeloscojone
    Frequent Visitor
    2 years ago

    HI Ibendlin,

     

    We're all running Power BI Desktop. There are 3 users which are able to load the Excel files without any errors. Then the other 4(myself included) can not refresh the report without the data refresh erroring on 2 of the 4 Excel workbooks which serve as the data source for the report.

     

    I will try what you suggested, and will update the post.

     

    Thank you for taking the time to reply- it is most appreciated!