Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi There,
The below code works totally fine when the table name is single word. If the table name has any spaces it is throwing error.
import json
import requests
# Replace with your Power BI tenant ID and client ID and client secret
tenant_id = ''
client_id = ''
client_secret = ''
# Workspace ID
workspace_id = ''
# Dataset ID
dataset_id = ''
# OAuth2 endpoint for token acquisition
token_url = f'https://login.microsoftonline.com/{tenant_id}/oauth2/token'
# Request body for token acquisition
token_data = {
'grant_type': 'client_credentials',
'client_id': client_id,
'client_secret': client_secret,
'resource': 'https://analysis.windows.net/powerbi/api'
}
# Request token from Azure
token_response = requests.get(token_url, data=token_data)
token_response_data = token_response.json()
# Check for token acquisition errors
if token_response.status_code != 200:
print({'statusCode': 500,
'body': json.dumps({'error': token_response_data.get('error', 'Failed to acquire token')})})
# Get access token
access_token = token_response_data['access_token']
api_url = f'https://api.powerbi.com/v1.0/myorg/groups/{workspace_id}/datasets/{dataset_id}/executeQueries'
# HTTP headers with authorization
headers = {
'Authorization': f'Bearer {access_token}',
'Content-Type': 'application/json'
}
payload = {
"queries": [
{
"query": "Evaluate 'Users'"
}
],
"serializerSettings": {
"includeNulls": False
},
"impersonatedUserName": "<your_user>@<your_domain>.com"
}
response = requests.post(api_url, headers=headers, json=payload)
print(response.text)
Pass Scenario: "query": "Evaluate 'Users'"
Fail Scenario: "query": "Evaluate 'Report views'"
Please let me know how we can pass the table names which has spaces.
Thanks,
Laxmikanth
Hi There,
Thanks for the update.
The 2nd method in the article mentions to enclose single quotes in double quotes and it has been done. It worked for the one worded table but doesn't work for the table names which have spaces.
Pass Scenario: "query": "Evaluate 'Users'"
Fail Scenario: "query": "Evaluate 'Report views'"
Thanks,
Laxmikanth
Shouldn't it be
"query": "Evaluate "'"Report views"'""
?
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
13 |
User | Count |
---|---|
91 | |
86 | |
46 | |
28 | |
21 |