Forum Discussion
JSON Web limited to 5000 records
kriswijnants,
It is not a bug of Power BI Desktop, but a limitation from Dynamics 365 side. You can check the following bligs about this issue.
https://crmchartguy.com/2017/09/30/use-fetchxml-in-power-bi-with-dynamics-365-customer-engagement/
https://www.inogic.com/blog/2015/07/querying-more-than-5000-records-in-dynamics-crm/
Regards,
Lydia
Hi v-yuezhe-msft,
Thanks for your reply. Do you have an example or blogs post you can share on how to implement the solution you proposed in PowerBI (https://www.inogic.com/blog/2015/07/querying-more-than-5000-records-in-dynamics-crm/)?
I hope the PowerBI and Dynamics teams can find a solution on this, as it is a showstopper for a PowerBI project we have ongoing now.
Regards,
Kris
kriswijnants,
The above method is implemented in Dynamics 365, I would recommend you post the question in Dynamics forum to get better support.
Regards,
LydiaHi Lydia,
I'll do so. Thanks for the advise.
Regards,
Kris