Dataflow: OData v4 keeps giving Error 400 - Bad Request

[Robin9700]

Hi all,

I have created a Dataflow with multiple tables, which are retrieved from our accounting system (Dynamincs 365 Business Central) using an OData v4-feed. The dataflow has been working perfectly, until BC got an update. Since the update, 1 of the imported tables shows an error-message when trying to refresh the dataflow in Power BI.

The weird thing is that all other tables do refresh individually, even though they all follow the exact same path, and nothing should have changed in the OData/api-link for this specific table. Also, Power BI is able to connect to the table and show me data (in the "Edit dataflow"-stage), but when trying to refresh the data, the error message occurs.

The specific error-message says the following: 
Error : DataSource.Error: OData: Request failed: The remote server returned an error: (400) Bad Request. (Sorry we just updated this page. Reopen it and try again.

Does anyone have an idea on what to do to get my dataflow working again?

If you need any more information to help me solve this problem, please let me know.

[v-henryk-mstf · Accepted solution]

Hi @Robin9700 ,

It is not possible to reproduce such errors at the moment. If you download the pbix file and refresh it in the power bi desktop, please check if it works properly.

And check out this document.

Troubleshooting refresh scenarios - Power BI | Microsoft Docs

Query work tracking data using OData - Azure DevOps | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and related operation screenshoots. Looking forward to your reply.

Best Regards,
Henry

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