Power BI API parameters

[jakubkral]

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 errors occurred. ({   "code": "ItemNotFound",   "message":

     | "Dataset parameters at positions 1 - 2 cannot be found in

     | 1xxxxx-4712-4xxxxc-9xx0-3xxxxxxa5df5",   "target":

     | "1xxxxxxd-4712-4aec-xxxxx-3dxxxxxxdf5" })

Im using in power querry 2 parameters. Server and Database, because our developers are pasting the right server and database. Funny thing is that all other reports works well this way and we have no problem. But this one is just messing it up. Can you help me please somehow? Or ask me anything for further info.

Thanks in advance for any advice.

[rohit1991]

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.

[Anonymous]

Hi @jakubkral 

Based on the information I found, here are a few steps you can take to troubleshoot and potentially resolve the issue:

Double-check the parameters you are using in Power Query. Ensure that the server and database names are correct and match exactly what is expected.

Check the dataset configuration, make sure that the dataset in question is correctly configured and that the parameters are properly set up. A small typo or misconfiguration can cause such errors.

Ensure that you have the necessary permissions to access the dataset. Sometimes, permission issues can lead to the "ItemNotFound" error.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.