Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.