DMV Queries using Power BI Rest Api executeQuery endpoint

Question

Hi community,&nbsp;I'm trying to build a cloud function that is querying the underlying measure meta data from the DMVs. To query the DMVs I'm using Python's request library using the following code:&nbsp;secrets = obt_sec()&nbsp; &nbsp; auth_result = auth()&nbsp; &nbsp; token = auth_result['access_token']&nbsp; &nbsp; headers = {'Authorization': f'Bearer {token}',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Content-Type': 'application/json'}&nbsp; &nbsp; body = '''{'queries' : [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {'query': 'select * from $System.MDSCHEMA_MEASURES'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'serializerSettings': {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'includeNulls': 'false'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }'''&nbsp; &nbsp; get_datasets = rq.get(f'https://api.powerbi.com/v1.0/myorg/groups/{secrets[5]}/datasets/', headers = headers).json() #---&gt; https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets-in-group&nbsp; &nbsp; response_data = get_datasets['value']&nbsp; &nbsp; metaData = {}&nbsp; &nbsp; for response in response_data:&nbsp; &nbsp; &nbsp; &nbsp; pbi_dataset = response['id']&nbsp; &nbsp; &nbsp; &nbsp; meta_request = rq.post(f'https://api.powerbi.com/v1.0/myorg/datasets/{pbi_dataset}/executeQueries', headers = headers, data = body).json()&nbsp; &nbsp; &nbsp; &nbsp; print(meta_request)&nbsp; &nbsp; &nbsp; &nbsp; data = {pbi_dataset: meta_request['value']}&nbsp; &nbsp; &nbsp; &nbsp; metaData.update(data)&nbsp; &nbsp; &nbsp; &nbsp; print(metaData)&nbsp; &nbsp; return metaData&nbsp;Problem is that when sending the post request to the DMV endpoint I'm getting the following error.&nbsp;&nbsp;{'results': [{'tables': [{'rows': [{'CATALOG_NAME': 'HASHED', 'CUBE_NAME': 'Model', 'MEASURE_NAME': 'Text_User', 'MEASURE_UNIQUE_NAME': '[Measures].[Text_User]', 'MEASURE_CAPTION': 'Text_User'}]}], 'error': {'code': 'DaxDataTypeNotSupported', 'message': 'Encountered a value of type System.Int32. This type is not supported.'}}]}&nbsp;I need some support in what and where I am doing the wrong thing!

ibarrau · Accepted Answer

Hi. The docs says "Only DAX queries are supported at this time. MDX and DMV queries are not supported."&nbsp;
You can't use DMV with ExecuteQueries endpoint request. It's on the limitations:&nbsp;https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries-in-group
I hope that helps,

Forum Discussion

DMV Queries using Power BI Rest Api executeQuery endpoint

1 Reply

Related content

PowerBI API not running query from executeQueries endpoint

Service Principal + RLS + ExecuteQueries REST API

Custom Endpoints - Eventstream

Refresh SQL Endpoint API

sql endpoint connection