Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Clear permissions in data source settings and try the latest version of Power BI Desktop.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |