Web api paramerized refresh data

[Mallikarjun]

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

[Mallikarjun]

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.

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.

Please guide to solve this

Best Regards,
Mallikarjun

[Eric_Zhang]

@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.

[Mallikarjun]

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

[Eric_Zhang]

---

@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.

[Mallikarjun]

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

[Eric_Zhang]

@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