Refresh dataflow entity from Flow

[Anonymous]

Hi guys, 

I have a problem, I have a pbix file with 15 tables, each obviously connected to a DB, then i ihave added another table linked to a sharepoint list, the 15 tables have an auto refresh schedule but because the list table is being updated every hour or less i need to have that data more in real time, my original plan was to update this list via Flow, which worked, however with this file in production seems i cannot refresh just that table without updating the other 15, so, does anybody has an idea how i can refresh this specific table linked from sharepoint individually using flow? again the main problem is due to memmory capacity i cannot refresh the whole dataset everytime there is a new item in list, i have been thinking using dataflow but it seems i may incurr in the same issue and i have no idea how to refresh a dataflow via flow.

Thanks 

[Anonymous]

HI @Anonymous,

I think these should more relate to data source management.
In my opinion, I'd like to suggest you create the data sources which stored huge amount of 'cold data'(common data or not often changed records) with import mode and manually/schedule refreshed frequency.
Then you can enable incremental refresh or use live mode to connect the data sources who have records often changes.

Regards,

Xiaoxin Sheng

[lbendlin]

selective refresh is not (yet) possible for developers.  XMLA Write operations will eventually allow that.  Have a look at ALM Toolkit for the current status of affairs.  Judging by the gateway logs internally this selective refresh is already happening.

In the meantime you could set your db data sources to incremental refresh or Direct Query.

(Technically Sharepoint Online data sources should automatically refresh every hour without impacting other data sources.)