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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
I_NeedMorePower
Helper III
Helper III

Why Importing Data is So Slow?

Greetings dears,

 

I'm trying to import a table from D365 FO Cloud Development Environment that has around 3 million rows.

Querying this table in SQL Server takes around 50 seconds, while importing this table in Power BI is REALLY slow.

The table is 200+ MB in size and It took 2 minutes to download 4 MB which is really slow compared to the network speed I'm connected to.

I tried multiple different networks but all the same.

Is this because of the D365 cloud development environment capabilities?

Or this is a normal behavior for the Power BI?

1 REPLY 1
Migasuke
Super User
Super User

Hi @I_NeedMorePower .
I have not personally worked with Dynamics but these are some general rules I know:

1. More transformations steps in Power Query = More time to import.
2. Different datasources has different speed of import.
3. Server, where your data is stored can be bottleneck.

I would do following:
1. Check if you really have lot of transofrmations in PQ.
2. Try to query the data somewhere outside of PBI. Like SSMS.
3. Check if your company has VPN, which might slower you down.


In case you find something, let me know.

 



If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.