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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
barbforsman
Resolver I
Resolver I

Unable to connect Power BI Desktop to Dynamics 365 after upgrade to v9

We recently upgraded our D365 to v9.  I can connect a new Power BI report to this environment using = OData.Feed("https://nebraskalink1.api.crm.dynamics.com/api/data/v9.0/")

but I am unable to update to this connection on my current reports. 

 

Do I have to start from scratch again, or is there a way to update the connection I already have?

Error when trying to update source

 

1 ACCEPTED SOLUTION

I ended up opening a ticket with Microsoft Support.  The new API model for v9 to use is

= OData.Feed("https://d365_instance.api.crm3.dynamics.com/api/data/v9.0", null, [Implementation="2.0"])

 

This connected successfully.  Unfortunately once I connected I ran into this issue

(400) Bad Request. (Number of calculated fields in query exceeded maximum limit of 10.)

 

I ended up rebuilding my report from scratch.  

View solution in original post

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@barbforsman,

 

Clear permissions in data source settings and try the latest version of Power BI Desktop.

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

I ended up opening a ticket with Microsoft Support.  The new API model for v9 to use is

= OData.Feed("https://d365_instance.api.crm3.dynamics.com/api/data/v9.0", null, [Implementation="2.0"])

 

This connected successfully.  Unfortunately once I connected I ran into this issue

(400) Bad Request. (Number of calculated fields in query exceeded maximum limit of 10.)

 

I ended up rebuilding my report from scratch.  

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.