Forum Discussion

b2wise's avatar
b2wise
Icon for Helper III rankHelper III
3 years ago

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

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!

 

2 Replies

  • 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?