Combine Dataflows data from different sources

[RSebastiani74]

Hello,

I have 3 datasets from different sources (different AWS databases) with the same schema for different clients that I CANT physically combine data for into a single database.  I am currently creating dashboards in PBI for each client and would like to combine all three client's data into a single logical database or datamart.  Can I combine the dataflows I created for each one of these tables separately into a single table into a datamart or other destination?  What are best practices and recommendations to be able to accomplish this?  Thank you!

[lbendlin]

Once your data is in the dataflow you have broken the data's chain of custody, and can do with the data whatever you want (for better or for worse).

Remember that dataflows are data storage vehicles (Parquet files, basically) so don't try to do too much with them.