Forum Discussion

BillyT_350's avatar
BillyT_350
Icon for Helper V rankHelper V
8 years ago

Difficulties Retreiving Data from Dynamics

I have been having some extreme difficulties loading data into Powre BI from Dynamics. Some small tables will load into Power BI after maybe 5 or 10 minutes, but larger tables (60,000 - 150,000 rows)...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

It is really slow to go against CRM online directly.  We ended up replicating the data to SQL for our reports.  You can used KingswaySoft components,  Microsoft data export or Scribe has a cloud based solution.

 

We evaluated the offering from Microsoft.. but it doesn't pull the optionset names and linked names in to the table like KingswaySoft and Scribe do.

  • BillyT_350's avatar
    BillyT_350
    Icon for Helper V rankHelper V
    8 years ago

    We have such a system already, but it only updates nightly, and we want these reports to be near-live. We have some tickets open with Microsoft and are exploring workarounds and other options.

    Besides, if we use another DB, what would be the point of having Dynamics?