Forum Discussion
jo123456
1 year agoHelper I
Dynamics 365
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
1 year agoSuper User
What's the M code you use? I use a dataverse connection to MSD 365 from Excel and don't have this problem...
- jo1234561 year agoHelper I
- isjoycewang1 year agoSolution Supplier
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?
- jo1234561 year agoHelper I
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.
- PwerQueryKees1 year agoSuper User
I am using
CommonDataService.Database("yourenvironmentid.crm.dynamics.com")