Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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) can take hours or days to load. We are expected to be creating live reports for folks in our company, but we can't actually get any of our live data to load in a timely fashion.

 

This has been attempting using the Get Data / Dynamics 365 (online) and OData Feed functionalities. We are also looking into our own custom FetchXML statements and the Get Data / Azure functionality. I am going to start seperate discussions concerning those, and will link them here when they are created.

Status: New
Comments
v-jiascu-msft
Employee

Hi @jengwt,

 

I would suggest you file a support ticket here to investigate more.

create ATicket

 

Best Regards,

Dale

jengwt
Helper V

I submitted a ticket before I opened this thread. I opened it because, in my experience, the community often knows better than the developer.

 

If that ticket is resolved, I will update this thread with the resolution and mark an answer.