How to determine refresh times for each query in a dataset?

[Anonymous]

I have a dataset that is admitedly very large and probably not very optimized. I'm trying to improve the refresh times of scheduled refreshes. Is there a way to view the query times/execution times on each query or each step within a query? I want to be able to complete an analysis to determine if there are tables in the dataset that are taking up bandwidth and could be removed.

Thanks.

[Mariusz]

Hi @Anonymous 

You can create a dataflow in the service, refresh it and see the refresh history, to the far right you will see dow arrow icon (download) this will download details for every query that was marked as enabled load.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Hi @Mariusz 

I am looking to optimize a dataset vs. a dataflow.

My dataset is sourced by multiple dataflows, and has additonal transformations applied on top.

IE: "Dataset" consists of "Dataflow 1", "Dataflow 2" and "Dataflow 3". I bring Datasets 1,2, and 3 into my dataset, and apply transformations, conditional columns, etc to each dataflow to obtain the final dataset. 

I'm trying to determine which of those three dataflow transformations is most demanding when refreshed. (Or even better which steps in the query are time consuming)