Forum Discussion
Refresh Data based on the user input box
Hi ,
I have just started to use PowerBI recently and find it well designed and flexible. I used Sql server reporting service in the past. We have decided to migrate to PowerBI. There is a feature that i have not found on reports rendered for PowerBI mobile. We want to have 2 input box Card_id and _Date for example, where the user can write values. Based on the value entered, only associated data will be collected directly from the database. (up to date data). I have seen "Direct Query" feature. The problem here is that the user input does not modify the query of the dataset. In one word, I need to have parameter feature like we have in Sql server reporting serivce.
Thank you for your help.
Thank you for this answer. I just understand that what i need is not possible for the moment.
anyway thank you so much for taking that time to answer to me.
2 Replies
HI Rogy,
Unfortunately, you can't use data view filters to interact with backend query tables connections. (date level: query table -> data model table -> data view table; child-level filters not able to affect parent level records)
Perhaps you can try to use query parameters to parameterize your connection string, but it not able to operate on the mobile side.
Edit parameter settings in the Power BI service
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
Regards,Xiaoxin Sheng
Thank you for this answer. I just understand that what i need is not possible for the moment.
anyway thank you so much for taking that time to answer to me.
