dataflow or datamart or dataset solution for creating table of point in time metrics

Hi GilbertQ thanks for the follow up response.

In this case i'm not looking to have data factory > dataflow gen2 process get data from azure storage account. 

I'm looking for it to get data from mysql database and write the results into azure storage account configured as standard issue storage account or for data lake storage gen2 functionality, i.e. hierarchical namespace.  

Then in power bi desktop app i want to configure a data source that pulls the data directly from that azure storage account populated by data factor > dataflow gen2 process vs from the dataflow gen2 source.

The reason being is using the data factory > dataflow gen2 source, as was the case with the power bi > dataflow <gen1> source,  as the power bi data source pulls back only the last record [ set ] written and not the cumulative record set from all timed executions of the data flow.

Again the reason for this is my dataflow mysql query produces a single record output where every column is a point in time calculated metric that i cannot compute at a later time down the road.

Displaying the combination of all these point in time calculated metric output rows is what allows me to produce a trending data charge.

Make sense?