Sync Failures

[fsd1235]

Hi,

My dataset sync seems to be failing. The source dataset is an Excel in OneDrive. I have a Power Automate workflow updating the Excel and that excel is still being updated. But the dataset sync to PowerBI is failing.

I tried to import the dataset again and receive a 400 status code. I checked permissions on my onedrive folder and I as admin have access to parent folder as well as main file. 

Does anyone have any ideas why the dataset sync is failing?

Thanks

[v-binbinyu-msft · Accepted solution]

Hi @fsd1235 ,

There could be several reasons why the dataset sync is failing. One possible reason is that the Excel file is open or in use by another user or application, which can cause the sync to fail. Another possible reason is that the Excel file has been moved or deleted, or the Power Automate workflow is not updating the file correctly.

To troubleshoot the issue, you can try the following steps:

1. Check if the Excel file is open or in use by another user or application. If so, close the file or wait until it is no longer in use.
2. Check if the Excel file has been moved or deleted. If so, restore the file or update the dataset connection to point to the new location.
3. Check if the Power Automate workflow is updating the Excel file correctly. If not, update the workflow or recreate it.
4. Check if the OneDrive folder and file permissions are set up correctly. Ensure that you have access to the parent folder as well as the main file.
5. Check if there are any errors or warnings in the Power BI service or Power Automate logs that could indicate the cause of the sync failure.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.