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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.