Forum Discussion

elliottlawlor's avatar
elliottlawlor
Frequent Visitor
1 year ago
Solved

One drive connected excel is no longer refreshing.

Hi, I have had a connection with One Drive for my Excel which is used as the dataset for all my reports. This suddenly stopped refreshing on the 28th Feb. I cannot get it to refresh. It is now called...
Need Help
  • collinq's avatar
    collinq
    1 year ago

    Hi elliottlawlor ,

     

    Normally, this is an error indicating that this is not "finding" the file.  Please confirm that EVERYTHING is exactly the same as it was before.  And, confirm that the data source in the gateway is reaching it.  The file name or path might have changed slightly

     

    OR, the permissions have changed.  I would expect the error to be a bit different if it was permissions though but it is possible.

collinq's avatar
collinq
Icon for Super User rankSuper User
1 year ago

Hi elliottlawlor ,

 

Normally, this is an error indicating that this is not "finding" the file.  Please confirm that EVERYTHING is exactly the same as it was before.  And, confirm that the data source in the gateway is reaching it.  The file name or path might have changed slightly

 

OR, the permissions have changed.  I would expect the error to be a bit different if it was permissions though but it is possible.

elliottlawlor's avatar
elliottlawlor
Frequent Visitor
1 year ago

Hi, I have just seen that around that time i had an issues with the excel file and excel created a copy of it. It has been renamed to the exact same file name but it could be a "different" excel even though it contained exactly the same data and was renamed to the same excel name in the same location on one drive.

 

How do i get this resolved to work again in power Bi online.

 

Thank you.