Forum Discussion

timcpnz's avatar
timcpnz
Frequent Visitor
1 year ago
Solved

Power BI OneDrive / Sharepoint Refresh fail

Hi,

This will probably be any easy one:
A PBIX file imported from Sharepoint will continually fail updating. It isn't the semantic model but the report itself.
I have deleted the report from PowerBI online multiple times.

The file is fine when viewed from Sharepoint Online. This problem has been occurring for weeks.
It seems to be only one report that fails

^^ The helpful message

Need Help
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi timcpnz ,

    Thank you for reaching out to us on the Microsoft Fabric Community Forum.

    Thank you for sharing screenshot ,information provided in the screenshot, it appears this issue might require deeper investigation from the Power BI support team.

    I recommend opening a Microsoft support ticket so they can trace the issue.

    To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

    Thank you

4 Replies

  • Shravan133's avatar
    Shravan133
    Super User
    1 year ago

     

    Power BI requires the SharePoint path to be in a specific format when publishing from SharePoint Online. The preferred format is:

     

     
    https://<yourtenant>.sharepoint.com/sites/<sitename>/Shared Documents/<folder>/<file>.pbix

    Make sure:

    • You used the “Web” connector (Get Data > Web) to import the file.

    • You did not use the local sync folder (e.g. C:\Users\...\OneDrive), even if the file is from SharePoint.

    • timcpnz's avatar
      timcpnz
      Frequent Visitor
      1 year ago

      Hi Shravan133 , thank you for that.

      1. I don't think it is a data source issue (see below)
      2. Confirmed the source is sharepoint, not a onedrive shortcut to sharepoint folder

      I just wanted to make clear that any data source from Sharepoint online as part of the semantic model is pulling through fine. So it isn't a data source issue. It is the physical report.

      For example:
      If I change a visual using Power BI Desktop and save to Sharepoint online, I would expect Power BI online to sync that change (over time - up to an hour). This is how I have configured all reports, so that I don't have to hit Publish on the desktop version. I also have better version control etc etc.

      I hope that makes sense

      H

  • v-dineshya's avatar
    v-dineshya
    Community Support
    1 year ago

    Hi timcpnz ,

    Thank you for reaching out to us on the Microsoft Fabric Community Forum.

    Thank you for sharing screenshot ,information provided in the screenshot, it appears this issue might require deeper investigation from the Power BI support team.

    I recommend opening a Microsoft support ticket so they can trace the issue.

    To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

    Thank you

    • v-dineshya's avatar
      v-dineshya
      Community Support
      1 year ago

      Hi timcpnz ,

       

      If you have raised a support ticket and received a resolution, please take a moment to post the details of that solution here on the forum. Sharing the fix you obtained will help others who encounter the same issue resolve it more quickly.

      Should you face any new challenges or have additional questions, feel free to reach out to the community we’re always here to help.

       

      Thank you