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
Master_T
Helper I
Helper I

Why is fetching data so slow?

Hello

 

I'm trying to develop a custom visual that needs a lot of data (about 500k rows).

I know from the documentation that fetching data from PowerBI is limited to 30k rows, but you can fetch more with a call to the fetchMoreData() api.

 

That approach works, but it's extremely slow. In my tests, every call to fetchMoreData(), which retrieves 30k rows of data at a time, takes 15-20 seconds for a table with 10 columns.... is such low performance normal? Or do you think there's something wrong on my end?

1 REPLY 1
Master_T
Helper I
Helper I

I've done some additional tests, and the thing that is even weirder is that the time required to fetch the next batch of rows using the fetchModerData() api seems completely unrelated to the amount of data that is retrieved. I've tried to set the dataViaMapping's window size to 3000 instead of 30000, and every fetch requires exactly the same time: about 20 seconds.


What is going on here? Is this an artificial limit imposed by PowerBI? Why is fetching data so absurdly slow??

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.

Top Solution Authors
Top Kudoed Authors