Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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:
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.
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:
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.