Forum Discussion
Input Parameters in Power BI Service
Hello All,
With few input parameters after loading the query/view into Power BI desktop the data is been loaded. Once again if a user wants to refresh the report using the Input Parameter such as using the date then is it possible to do in Power BI or is there any different approach?
What about adding input fields to the report in Power BI Service? Can user himself change the data without using Slicer/Filters? Primarily using Input Parameters?
Regards,
Chanukya
5 Replies
Hi chanukya_p,
Based on my test, I am afraid you could not change the data in Power BI service by using the Parameter. It's only supported in Power BI desktop. If we publish the report which has query parameter values, the report display in servcie is the same as the saved results in desktop. Please vote this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13820190-power-bi-online-query-parameters
Regards,
Daniel He
Hello Daniel,
Thanks for your reply. That's a big negative feature missing. However, can you clear me on more point regarding the below?
1. While loading the HANA View it will pop up for input parameter in Power BI Desktop and then the data is loaded using Direct Query option.
2. Is it possible to pass this input parameter in Power BI service still so that end User wants the parameter on his own?
Correct me if my understanding is wrong.
Regards,
Chanukya
Hi chanukya_p,
The Input Parameters cannot be passed to the report in Power BI Service. The Parameters can be passed only to a Power BI Template file and that too restricted to Desktop
Hello Thejeswar,
Thanks for your reply. Is there any alternate way to pass the input parameters in Power BI desktop to Power BI service?
Regards,
Chanukya
Hi chanukya_p,
Not likely there is a workaround for pasing Input parameters to service, as far as I know
There is one way you can alternatively handle this. But it might or might not satisfy your need
As long as there is no any column that works based on your parameters, you need not have to allow users to provide input parameters.
You can alternatively provide the users to select the same using slicers. But the limitation is you might have to redesign the report to work using slicers
If slicers are not desired, you can give the users select the same using Visual filters/ page level filter/ report level filters
