Forum Discussion
Dynamics 365 OData error with Power BI desktop
Excellent, that got it working. Thanks.
Ok, so I am sorry I don't understand.
I entered the information in a blank query as identified and it returned the information as rows in the query results but what do I do from there? I am sorry, I was thinking I would have the ability to show a list of tables and then join them together, etc. I don't see this.
Sorry if stupid question.
dpoggemann - You might need to add the entity name at the end of the URL to pull records into tables. In Dynamics CRM, the entity names should be pluralized.
For example (Advanced Editor code):
let
Source = OData.Feed("https://my_org_name.api.crm.dynamics.com/api/data/v8.2/new_myrecords"),
in
Source
You can create queries for each record type that you need. I would recommend creating "Shaped Tables" if you need to join multiple record types. That is to say, keep the queries basic, and then create new tables based on the queries that can merge, sort, filter, group, etc.
I hope this helps.