Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
nsacker
Regular Visitor

Connecting to D365: Data source error 400 Bad request - access to data entites in D365

Hi all,

 

I am connecting to Dynamics 365 for finance and operations and when I try to connect to certain tables I get an error message.

 

DataSource.Error: OData: Request Failed: The remote server returned an error: (400) Bad Request. (An error has occurred.)

DataSourceKind = OData

DataSourcePath = https.....

 

Does this mean that I do not have access to the data entity in Dynamics 365 and would need to get my permissions changed?

 

Thanks

1 REPLY 1
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@nsacker,

Are you able to access Dynamics 365 from web browser? I follow the guide in this article to connect to Dynamics 365 online in Power BI Desktop and select some tables, everything works well.

In your scenario, I would recommend you use Fiddler to monitor the Http traffic between Power BI Desktop and Dynamics 365, and check what is going on in the background. And you can share fiddler trace log to me via Private message.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.