Forum Discussion

dimitrievski's avatar
dimitrievski
Frequent Visitor
9 years ago

Dynamics CRM 365 data import in Power BI from view

Hello all,   I am trying to pull data from Dynamics CRM into Power BI. In CRM instance, there are views that contain exact data that I need to report on. I know that I can export to Excel and then ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

dimitrievski,

Please check the last screenshot in that blog, the URL is formatted as <API address >/incidents?fetchXml=<URI we got>. 

Click “Get Data->Blank Query” to add a new blank query in Power BI Desktop, then paste the following code in Advanced Editor.

let
    Source = Json.Document(Web.Contents("<API address >/Opportunity?fetchXml=<URI we got>")) 
in
    Source



Regards,
Lydia

RV1's avatar
RV1
Icon for Helper I rankHelper I
8 years ago

Doesn't fetch xml have a limitation of 5000 records? What do we do if we are dealing with a large dataset?