Find load times of individual tables in a model

[pb_user31]

Hi

I would like to find the invidual loading times per table in a model. Performance analyzer just gives me the load times of a page, its visuals & dax queries.

I need to find the individual load times per table query.

is this possible? I tried in DAX studio also but this is giving me the size and number of rows per table.

pb

[tackytechtom]

Hi @smpa01 ,

I think you need to define the specific dataset that you would like to fetch the meta data from. However, I am sure you could write a function in M that automates that for you meaning it would loop over all your datasets in the workspace concatenating the query results for the DMV.

I happen to have written a blog post that I published a couple of minutes ago about how to fetch DMV data into a Power BI report. 

https://www.tackytech.blog/how-to-build-meta-reports-on-top-of-power-bi-datasets-with-dynamic-manage...

I hope that helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[smpa01]

@tackytechtom  this is my guy

select * from $SYSTEM.MDSCHEMA_CUBES

[tackytechtom]

Hi @pb_user31 ,

You could query the DMV TMSCHEMA_PARTITIONS where that information is apparent. Together with the TMSCHEMA_TABLES you could create the following table:

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[smpa01]

@tackytechtom Is it possible to write a DMV query that gives me the refresh time of each dataset on a workspace, don't have a lot of experience aroound DMV or what it is capable of.

I need a dashborad that shows the last refresh time of any given power bi dataset ?