Forum Discussion
Dynamics 365 OData error with Power BI desktop
Excellent, that got it working. Thanks.
Helper IHi,
1. I'm new to Power BI
2. I'm connecting to a company that hasn't had CRM online connected to PowerBI before.
Several clients are getting the invalid metadata
For the company I am currently trying I have tried the above solutions and the closest I've come is it connecting but I have no tables showing to connect to. Is something wrong?
if i can see the metadata does that mean it's externalized properly? also say I'm connecting to appsource and it's using the office 365 account for the connection what authentication method should I be using?
very grateful for any help.
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.
- pcowman
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
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.
- pcowman
I get the remote name could not be resolved. Weird. I could connect before.
Compare the URL you are using to what you find in CRM under Settings -> Customizations -> Developer Resources
Mine looks something like this:
