Forum Discussion
How to use parameter in Power BI
Hello,
This is my web URL to load the data: https://www.alphavantage.co/query?function=DIGITAL_CURRENCY_DAILY&symbol=BTC&market={Currency}&apikey=LRMSZE7RIJ1YAL7F
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.
3 Replies
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. :smileyhappy:
Reference:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Regards
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?
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 :)
