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 Pow...
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

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