Forum Discussion
Dynamics 365 OData error with Power BI desktop
Excellent, that got it working. Thanks.
Try:
Get data: Other > Web
Basic: Add in URL table > https://yourD365instance.api.crm3.dynamics.com/api/data/v9.0/tablename
List, To Table, Ok, Column 1 Double Arrow
Sort from Natural Order to Name
Uncheck "User original column name as prefix"
Please confirm that works?
MS support engineer said if you're CRM instance is above 9.0.2.751, it will now include the fix and Power shouldn't have the issue anymore.
pcowmanHelper I
Several customers had their appsource start working last week. Definitely a backend problem.
9.0 and 8.2 within your URL source with both work now too
9.0.2.751 also began enforcing 10+ calculated field query limits in powerbi (some other apps have had this limitation for a while now).
We kept having intermittent issues with powerbi the last few months so we made the move to azure sql data export service. Not too hard to do (Have to change your reports a bit or a lot depending on the report/datasets). Azure sql refreshes incredibly faster and offloads the resources from dynamics if you have a lot of powerbi reports/queries like we did.
I am still getting the error
Details: "OData: The given URL neither points to an OData service or a feed: 'https://***.api.crm.dynamics.com/api/data/v9.0/'."
There seems to be intermittent service disruption. D365 was down on Friday. Today it's fine, but previous the refresh of it on Power BI service wasn't working an hour ago. The .pbix refreshed fine.
Correction, manual refresh of the dataset works, but schedule refresh is producing an error.
