OneDrive Refresh failed

[Zhaodan]

Hi All,

I created a PowerBI report in Aug. I put my local pbix file to SharePoint and connected it as dataset on Service. Then I opened the OneDrive refresh to make sure online report can refresh in time. 

It was working fine, untile I tried to update pbix today. OneDrive refresh failed.

Firstly I thought the connection was lost and I need to reconnect and create a new online report. I did this, then I found the new online report also failed to OneDrive Refresh without any error info. 

Please help to check and here are details: 

Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID: 597ca87d-cb8e-4a59-b865-771f0499947e
Request ID: 0966a335-ffa9-4289-aec8-95bfedff49c7
Time: 2022-09-27 10:22:12Z

P.S. My data is stored in West Central US.

Thanks,

Zhaodan 

[v-jianboli-msft]

Hi @Zhaodan ,

Unlike a dataset refresh during which Power BI imports data from a data source into a dataset, OneDrive refresh synchronizes datasets and reports with their source files. By default, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization.

Power BI performs refresh based on an item ID in OneDrive, so be thoughtful when considering updates versus replacement. When you set a OneDrive file as the data source, Power BI references the item ID of the file when it performs the refresh. 

You can move the file to another location (using drag and drop, for example) and refresh will continue to work because Power BI still knows the file ID. However, if you copy that file to another location, a new instance of the file and a new fileID is created. Therefore, your Power BI file reference is no longer valid and refresh will fail.

For more details, please refer to:

Data refresh in Power BI - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Zhaodan]

I knew this. I didn't copy my pbix file. I just updated it. I don't think I did anything to change the item ID. Expecially I finished following things in 15 minutes to test OneDrive refresh. 

1. I created a report, which dataset (pbix) is from SharePoint. 

2. I updated pbix file and I hoped to see online report to OneDrive refresh. 

3. Failed to OneDrive refresh.