Issue with table names having spaces

Laxmikanth — Tue, 30 Apr 2024 15:02:30 GMT

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

Re: Issue with table names having spaces

lbendlin — Tue, 30 Apr 2024 22:11:40 GMT

Python String – Escape single quote (pythonexamples.org)

Re: Issue with table names having spaces

Laxmikanth — Mon, 06 May 2024 14:38:52 GMT

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

Re: Issue with table names having spaces

lbendlin — Mon, 06 May 2024 14:41:58 GMT

Shouldn't it be

"query": "Evaluate "'"Report views"'""

topic Issue with table names having spaces in DAX Commands and Tips

Issue with table names having spaces

Re: Issue with table names having spaces

Re: Issue with table names having spaces

Re: Issue with table names having spaces