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.
- 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:
