Forum Discussion

jakubkral's avatar
jakubkral
Frequent Visitor
1 year ago

Power BI API parameters

Hey everyone, I have this problem. In our company we are using azure, and we are posting reports online. The thing is that one report is throwing an error like this:   ~~      | One or more error...
Need Help
rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

The error indicates Power BI cannot find the Server and Database parameters. Here's how to fix it:

  1. Validate Parameters: Check the dataset in Power BI Service under Settings > Parameters. Ensure Server and Database are defined and populated.

  2. Verify in Power BI Desktop: Open the report, go to Transform Data > Manage Parameters, and ensure the Server and Database parameters are correctly configured and used in the data source.

  3. API Parameter Binding: If using the REST API, confirm Server and Database are included in patchParameters or bindToGateway calls.

  4. Gateway Configuration: Ensure the gateway is online and correctly mapped to the data source with these parameters.

  5. Refresh and Test: Republish the report and refresh the dataset to validate the changes.

Ensure parameter names match exactly across all configurations.