topic Re: why parameter definitions is not showing for shared dataset in power BI report server in Report Server

why parameter definitions is not showing for shared dataset in power BI report server

saranrajk — Tue, 17 Dec 2019 12:33:51 GMT

Hi,

When I'm calling the API for getting parameter definitions I'm getting an empty array,

http://ServerName//reports/api/v2.0/Datasets(dataset_id)/parameterDefinitions

{

"@odata.context": "http://servername/reports/api/v2.0/$metadata#ParameterDefinitions",

"value": []

}

But I've set the parameters in the shared dataset

How to resolve it

Thanks in advance.

Re: why parameter definitions is not showing for shared dataset in power BI report server

d_gosbell — Wed, 18 Dec 2019 00:05:40 GMT

I just tested this scenario on my local server and this api worked fine and returned the parameter defined on my dataset. This would suggest that maybe something went wrong with the deployment and the version on the server does not match the version in the designer.

When you go to http://[servername]/reports/api/v2.0/Datasets does it say that your dataset has parameters?

Re: why parameter definitions is not showing for shared dataset in power BI report server

saranrajk — Wed, 18 Dec 2019 13:46:27 GMT

Yeah, I'm getting the list of the dataset, I'm getting a response as hasParameter : False,

and I'm using SSDT 2017, SQL Server 2017 and Microsoft Power BI Report Server Version 15.0.1102.646.

Re: why parameter definitions is not showing for shared dataset in power BI report server

d_gosbell — Wed, 18 Dec 2019 19:27:15 GMT

saranrajk wrote:

Yeah, I'm getting the list of the dataset, I'm getting a response as hasParameter : False,

So that sounds like the version of the dataset on the server and in SSDT are not the same. Maybe try deleting the one off the server and re-deploying it from SSDT or deploying it into a new location on the server.

Re: why parameter definitions is not showing for shared dataset in power BI report server

saranrajk — Thu, 19 Dec 2019 13:18:34 GMT

I have tried and it is working now but what is causes this version compatibility because again stuck with error and I have recreated a new dataset.

Also, help me with the following errors.

Following are screenshots of my parameter and query in the dataset

when I call the following API

http://<server name>//reports/api/v2.0/DataSets(datasetID)/Data

I'm getting data is not process error.

what makes this kind of error.

Thanks in advance

Re: why parameter definitions is not showing for shared dataset in power BI report server

d_gosbell — Thu, 19 Dec 2019 19:23:22 GMT

saranrajk wrote:

I'm getting data is not process error.

what makes this kind of error.

The "query text" in a dataset needs to be just a single SELECT statement that returns a single rowset you cannot have mulitple statements in there with declare, set, begin, end etc. If you need complicated logic like that you need to create a stored procedure and then call that from your dataset.