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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Employee
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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors