jfreyman's avatar
jfreyman
New Member
2 years ago
Status:
New

Get Dataset Sizes Through API

For administrators, it can be useful to occasionally monitor the sizes of their Power BI Datasets. For individuals managing data models in Azure Analysis Services, they can submit DAX queries to the DMV $SYSTEM.DISCOVER_DB_MEM_STATS. However, administrators of PBI Datasets are met with "The '[email protected]' user does not have permission to call the Discover method.".


It would be greatly beneficial to be able to query dataset sizes through the following API paths:

URL: https://api.powerbi.com/v1.0/myorg/admin/datasets

Reference: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-as-admin


URL: https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets

Reference: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets-in-group


URL: https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}

Reference: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-dataset-in-group


URL: https://api.powerbi.com/v1.0/myorg/datasets

Reference: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets


URL: https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}

Reference: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-dataset

Recent ideas