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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Manually refresh individual table(s) in dataflows

In the Power BI web service we often setup dataflows containing multiple tables (for example from Dataverse) and as part of the iterative development of dataflows we have to modify the tables, sometimes only one table, and rather than refreshing the entire dataflow it would be helpful to be able to trigger a refresh for a single (or select multiple tables) in the web service so that we don't have to wait for all the data to refresh. We only want to update/refresh to the single (or multiple) changed tables.

Status: New
Comments
bert_demets
New Member

Yes, agreed this would help a lot.

Best solution to avoid this now is to create one query per dataflow, but would be much easier if we can contain all queries in one dataflow, but refresh them separately if wanted.

Jash_Jacob
New Member

I cannot agree more. I have a dataflow where the queries take around 10 to 15 minutes to run during certain runs (I am guessing heavy traffic is the reason). Considering that it wouldn't make sense to split them into multiple DataFlows, it is really frustrating when I have to fix one of the tables and have to wait for about an hour for it to reflect the value in the output. That is not a comfortable wait time most of the time. You might say I need to tune up the query, but considering the connection type, there isn't much control on my hand.

fbcideas_migusr
New Member
Status changed to: New