Dynamics 365

[jo123456]

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.

[PwerQueryKees]

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

[jo123456]

[PwerQueryKees]

I am using 

CommonDataService.Database("yourenvironmentid.crm.dynamics.com")

[isjoycewang]

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?

[jo123456]

do you know how I can identify the folder path for the table I'm connecting to if I use the dataverse route? I'm a bit new at the crm side.

[isjoycewang]

As @PwerQueryKees mentioned, you can find the path in your address bar when you open the Dynamics 365 system. Just attached the screenshot for your reference. Thanks. 

[PwerQueryKees]

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.

[Expiscornovus]

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]

dynamics 365 CRM

[Expiscornovus]

You can also use the Table.GenerateByPage helper function:

https://learn.microsoft.com/en-us/power-query/helper-functions#tablegeneratebypage