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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
DarkModePleez
Frequent Visitor

How to pre-cache (in the background) a Python visualisation on filtered data

Hi,

I'm using a Python visual in a report. It's a ggplot2 linechart with several graphs/curves. There are slicers in the report. When I open the report in Service, the first time I use the slicer to filter data it takes 5-10 seconds for the Python visual to compute. If I unselect and reselect the same filtering, it takes about half a second. Why? How to make it take half a second the first time?

In my understanding, the report runs the Python script the first time I use the slicer, then caches the data and uses the cached data the second time the filtering is chosen. Is there a way to make PowerBI precalculate and cache a selection/filtering on data? IS there a way to make PowerBI load Python script runs in the background? 

1 REPLY 1
lbendlin
Super User
Super User

No, that is not currently possible. The queries for the visuals on a page are only run when the visual is rendered.

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.