Forum Discussion

jo123456's avatar
jo123456
Icon for Helper I rankHelper I
2 years ago

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.
Need Help
Tips and Tricks
PwerQueryKees's avatar
PwerQueryKees
Icon for Super User rankSuper 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's avatar
    jo123456
    Icon for Helper I rankHelper I
    2 years ago

     

    • isjoycewang's avatar
      isjoycewang
      Icon for Solution Supplier rankSolution Supplier
      2 years 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?

       

      • jo123456's avatar
        jo123456
        Icon for Helper I rankHelper I
        2 years ago

        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.

    • PwerQueryKees's avatar
      PwerQueryKees
      Icon for Super User rankSuper User
      2 years ago

      I am using 

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