topic Re: Power bi report using web api with querystring parameterized and stored procedure in Developer

Web api paramerized refresh data

Mallikarjun — Fri, 24 Feb 2017 09:22:28 GMT

Hi,

I am using stored procedure with parameters which gets data based on the parameter passed and using this through web api I have
created a power BI report and published and embedded in web page which is always showing me the same data and not based on the parameter which I pass.

I want the power bi report to show the data based on the parameter which I pass in the querystring of the
web api url and web api gets data using stored procedure and that should be shown in power bi report.

Best Regards,
Mallikarjun

Power bi report using web api with querystring parameterized and stored procedure

Mallikarjun — Fri, 24 Feb 2017 08:57:05 GMT

Hi,

I am using web api and stored procedure with parameters, which gets data based on the parameter passed and using this through web api I have created a power BI report and published and embedded in web page which is always showing me the same data and not based on the parameter which I pass.

Please guide to solve this

Best Regards,
Mallikarjun

Re: Power bi report using web api with querystring parameterized and stored procedure

Eric_Zhang — Sat, 25 Feb 2017 07:19:06 GMT

@Mallikarjun

So in your case, the data source is "get date"->web and you are trying to send requests to the same web api but with different parameters? May I know how do you "pass in the querystring of the web api url", AFAIK, the dataset for the reports that published in Power BI Service doesn't accept any parameter.

By the way, I see you mentioning embed in web page, in case you would have any interest, check How to Embed and Filter a Power BI Report with the new Power BI Embedded JavaScript API.

Re: Power bi report using web api with querystring parameterized and stored procedure

Mallikarjun — Mon, 27 Feb 2017 05:25:36 GMT

Hi,

You are right I am passing different parameters to the published power bi report. I am passing as http://localhost:51919/api/getdbinfo/GetCustomerByID/?customerID=1

Based on the customerID value report should be generated in the published power bi report

Best Regards,
Mallikarjun

Re: Power bi report using web api with querystring parameterized and stored procedure

Eric_Zhang — Tue, 28 Feb 2017 07:08:04 GMT

@Mallikarjun wrote:

Hi,

You are right I am passing different parameters to the published power bi report. I am passing as http://localhost:51919/api/getdbinfo/GetCustomerByID/?customerID=1

Based on the customerID value report should be generated in the published power bi report

Best Regards,
Mallikarjun

@Mallikarjun
That's actually what confuses me. Dataset for the reports that published in Power BI Service doesn't accept any parameter, how can you do that? AFAIK, we can only change the URL/parameter in the Power BI Desktop.

Re: Power bi report using web api with querystring parameterized and stored procedure

Mallikarjun — Tue, 28 Feb 2017 07:13:38 GMT

I need the dataset to be refreshed each time based on the parameter, please let me know how this can be achieved using web api and power bi published report or best alternate approach

Re: Power bi report using web api with querystring parameterized and stored procedure

Eric_Zhang — Thu, 02 Mar 2017 02:55:59 GMT

@Mallikarjun

AFAIK, there's no parameter in Power BI Service and we can't change the api's querystring via any Power BI API. You can submit your idea at Power BI Ideas and vote it up.

The only approach would be changing the querystring in desktop and re-publish, Or maybe instead of load one parameter at a time, you can import all the data and view specific via slicer, this thread may give you some inspiration