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.
3 Comments
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.
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.
- Status added:New
