Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, I am facing an issue while trying to change Report parameter values on power bi service using api request call using the syntax provided in the power bi documentation.
The query that I am sending using python is as below
dest = 'https://api.powerbi.com/v1.0/myorg/groups/' + self.group_id + '/datasets/' + self.dataset_id + '/Default.UpdateParameters'
headers = {'Authorization': 'Bearer ' + self.access_token}
data = {"updateDetails": [{"name": "ScenarioID","newValue": "110"},{"name":"ChildID","newValue":"13"}]}
Param = requests.post(dest, data=data, headers=headers)
Which is giving me below response
{'error': {'code': 'InvalidRequest',
'message': 'Dataset Parameters list is invalid in DatasetID. Reason: Invalid parameter update details',
'target': 'DatasetID'}}
I am unable to understand how to resolve this I have parameters defined as
Required box ticked.
Type Decimal Number (I have tried it with text type as well)
suggested values: any
Current Value 108
Please help!
Try this:
dest = 'https://api.powerbi.com/v1.0/myorg/groups/' + self.group_id + '/datasets/' + self.dataset_id + '/Default.UpdateParameters'
body= {
"updateDetails": [
{
"name": "DataBase",
"newValue": "myDB"
},
{
"name": "Server",
"newValue": "123.456.789"
}
]
}
header = {'Content-Type': 'application/json'
,'Authorization': f'Bearer {tokenPBI}', 'Accept': 'text/plain'}
requests.post(dest,
data=json.dumps(body),
headers=header
)
Regards
It seems quite a trivial problem but I am unable to figure out the solution.
Please help as it is quite important for my client.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
40 | |
4 | |
4 | |
3 | |
3 |