How to use parameter in Power BI

[tomk]

Hello,

This is my web URL to load the data: https://www.alphavantage.co/query?function=DIGITAL_CURRENCY_DAILY&symbol=BTC&market={Currency}&apike...

The Currency is a parameter as can be seen in the URL. This is the screenshot of the configuration

Now I want to embed this report (iframe) in my custom website. But when I do that I do not get selection for selection of currency.

Only when I export it as template and open it in Desktop I am able to see the currency dropdown selection option. But I need this feature when embedding report in my custom web application. Why is the dropdown not coming up? What would I need to do?

Thank you!

Best regards,

TomK.

[v-ljerr-msft]

Hi @tomk,

Now I want to embed this report (iframe) in my custom website. But when I do that I do not get selection for selection of currency.

---

Query Parameters can be referenced via the UX dialogs for most common operations in Power BI Desktop’s “Get Data” & “Query Editor” experiences: Data Source connection dialogs, Filter Rows and Replace Values. But cannot be directly used on the report.  So it won't work in your scenario currently. 

Reference:

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Regards

[tomk]

@v-ljerr-msft

If you know please let me know because I am exploring Power BI for my application but it misses some really important basic features (or I am missing something! :S)

Thank you so much 🙂

[tomk]

Thank you @v-ljerr-msft

So what options do I have? This looks like a regular scenario isn't it? How do I pass in parameters to my web service and fetch data as per those parameters and yet have the report in my custom Asp.Net web application?

Is not possible at all?