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?