Forum Discussion

KojoBeef's avatar
KojoBeef
Regular Visitor
1 year ago
Solved

Data Source - Excel on the Web - Stopped Working

Hello!   Withing the past few months my graphs stopped auto-updating and I havn't been able to pin point the issue. My data source is an Excel Online doc provided from a user that was suppose to au...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    Hi KojoBeef ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you lbendlin  for the prompt response.

     

    • Open the Excel file in your browser and confirm it still exists and hasn’t been moved or renamed.
    • In Power BI, use Get Data -> Web, and paste the current working URL of the Excel file from your browser.
    • Instead of "Web", use Get Data -> SharePoint Folder and enter the site root (e.g., https://yourtenant.sharepoint.com/sites/SITENAME), then filter for your file.
    • Go to Data source settings in Power BI and ensure you're signed in with the correct account (usually organizational login).
    • If published, check Scheduled Refresh settings and logs for errors.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thank you!!

v-sathmakuri's avatar
v-sathmakuri
Community Support
1 year ago

Hi KojoBeef ,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you lbendlin  for the prompt response.

 

  • Open the Excel file in your browser and confirm it still exists and hasn’t been moved or renamed.
  • In Power BI, use Get Data -> Web, and paste the current working URL of the Excel file from your browser.
  • Instead of "Web", use Get Data -> SharePoint Folder and enter the site root (e.g., https://yourtenant.sharepoint.com/sites/SITENAME), then filter for your file.
  • Go to Data source settings in Power BI and ensure you're signed in with the correct account (usually organizational login).
  • If published, check Scheduled Refresh settings and logs for errors.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thank you!!

KojoBeef's avatar
KojoBeef
Regular Visitor
1 year ago

Thanks! Like the other comment stated I had to end up changing the connector to the Sharepoint Folder. Not sure why the origional connector for Excel stopped working, but this is a work around for now.

 

Thanks!