How do I share a table across datasets with on demand refresh?

[b2wise]

Hi all,

I have a table that I create in Power Query combining multiple csv files and doing some transformations. The csv files are being updated all the time, say every five minutes, and having the most up to date data is essential.

I would like to use have this table used by multiple datasets and allow for all these datasets to refresh this table on demand. I don't think this is possible with datamarts or dataflows.

Right now I duplicate the query and table for each dataset but I would like to just have one table for easier maintenance and simplicity.

How do I do this?

Thanks in advance!

[b2wise]

@amitchandak Thanks, but how do I refresh the dataflows and dataset at the same time? I've seen mention of power automate but what if I have multiple dataflows and they have to be refreshed in a specific order?

Sounds like a bigger headache than duplicating queries in multiple datasets. No?

[amitchandak]

@b2wise , Use dataflow. Let it duplicate data in files. But logic should be in one place.