I am connected to CRM for a report and only 5000 records are being returned when I have 6000. Is there a workaround to get all the rows in the data? Thank you.

The domain name of the instance of MSD you are using. You can take it from the address bar in your browser when you have the system open. See my other post for a simple example.

Hi jo123456, Most APIs would have some kind of pagination/paging functionality. What are you using for your connection? Dynamics 365 CRM? Here is an example for Dataverse paging:https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query/page-results

What's the M code you use? I use a dataverse connection to MSD 365 from Excel and don't have this problem...

Dynamics 365 | Microsoft Fabric Community

10 Replies

Expiscornovus
Most Valuable Professional
2 years ago
Hi jo123456,

Most APIs would have some kind of pagination/paging functionality. What are you using for your connection? Dynamics 365 CRM?

Here is an example for Dataverse paging:
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query/page-results
- jo123456
  Helper I
  2 years ago
  dynamics 365 CRM
  - Expiscornovus
    Most Valuable Professional
    1 year ago
    You can also use the Table.GenerateByPage helper function:
    https://learn.microsoft.com/en-us/power-query/helper-functions#tablegeneratebypage
PwerQueryKees
Super User
2 years ago
What's the M code you use? I use a dataverse connection to MSD 365 from Excel and don't have this problem...
- jo123456
  Helper I
  2 years ago
  - isjoycewang
    Solution Supplier
    1 year ago
    Not sure but it looks like you're connecting to a web content or some documents instead of directly connecting to CRM? If so, please check the raw file that you connected to.
    
    Or would you consider using the default Dataverse option to connect to MSD 365?