Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
5 hours ago

Refresh Failed

I recently connected an Excel file to one of my PowerBI reports and now the automatic overnight refreshes have stopped working.

I had previously done the same thing with a different report and it worked (it was 2 years ago and it was very straightforward). Now, after repeating the exact same type of connection it won't work - I've look at the solutions and I'm lost. There's so much technical language now I don't know how to resolve it.

Can anyone provide me clear and easy to understand steps to fix this please? I am not a developer so I haven't got a clue about Gateways etc. Its an excel file saved in a folder in OneDrive.

Any help will be much appreciated.

 

Need Help
power bi
Show and Tell

5 Replies

  • rampie's avatar
    rampie
    Icon for Kudo Commander rankKudo Commander
    37 minutes ago

    Try this: open the workbook in OneDrive from the browser, go to ... > Details and copy the Path. Then in Power BI Desktop use Get data > Web, paste that link and sign in with Organizational account. Point your query to that new source (or in Advanced Editor swap the File.Contents("C:\...") part for Web.Contents("<the link you copied>")), republish, and in the Service set the data source credentials to OAuth2.

     

    Steps are here: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

     

    Hope this helps!

    https://www.linkedin.com/in/richard-ampie-218a07247/

  • v-sathmakuri's avatar
    v-sathmakuri
    Icon for Community Support rankCommunity Support
    5 hours ago

    Hi ArchStanton​ ,

    Thank you for reaching out to fabric comunity.

    1. Open Power BI Desktop and go to Transform data -> Data source settings.
    2. Check whether the Excel file is connected using a local OneDrive path (e.g., C:\Users\....\OneDrive).
    3. Reconnect using the Excel file's cloud location in OneDrive or SharePoint Online.
    4. Republish the report.
    5. In Power BI Service, open Semantic model settings -> Data source credentials and sign in again.
    6. Test the refresh and reconfigure scheduled refresh.

    Refresh a semantic model created from an Excel workbook - cloud - Power BI | Microsoft Learn

    Thanks!!

    • ArchStanton's avatar
      ArchStanton
      Icon for Power Participant rankPower Participant
      5 hours ago

      Thanks for your quick reply.

      I can confirm that my file is connected using a local OneDrive path

      How do I carry out No 3? Do I go into Get Data again and select something different to excel workbook?