Get the dataset sizes before and after the refreshes

[Anonymous]

Hi All,

Request to help on how to get the dataset sizes before and after the refreshes in PBI service. Please guide me through any articles or PowerShell scripts if exists to get the above.  you may suggest for any alternatives.

Have explored on REST APIs Ref as below but this doesnt have any information on Size of the datasets.

Ref : https://docs.microsoft.com/en-us/rest/api/power-bi/admin/getrefreshablesforcapacity

Thanks in advance.

Regards,

Arjun DN

[lbendlin]

Run DMV queries against the XMLA endpoint

select [Name], [ModifiedTime], [RefreshedTime] from $SYSTEM.TMSCHEMA_PARTITIONS

select * from $SYSTEM.DISCOVER_OBJECT_MEMORY_USAGE where [OBJECT_ID]='IMBIData'

etc.