How to let user enters value in PBIRS

Anonymous · ‎10-21-2019

Hi everyone,

I am looking for a way to let user enters value by pass parameter in report page not from toolbar edit parameter. An additional, I am using a PBIRS for my organization. Now my issue is how to let user to pass a value in function from Oracle Database. It most be enter date every time to bring specific results because without enter value will bring a huge date from Oracle Database and that will effect on server. I will share with you some of pictures maybe will help you understand the situation.

Thank you

d_gosbell · ‎10-27-2019

@Anonymous wrote:
I am looking for a way to let user enters value by pass parameter in report page not from toolbar edit parameter

You can't do this with query parameters in Power BI, the can currently only be changed from the edit parameter dialog.

If you can't bring the full dataset into a Power BI file your other options would be to maybe build a SSAS tabular model and use a Live Connection from you Power BI report. (with SSAS tabular you could maybe use partitioning to more efficiently load the data as opposed to doing a full refresh every time)

Or you could look at building a paginated report instead of a pbix based one. Then you can definitely pass parameters to your oracle function, but you are more limited in the sorts of visualizations you can use an the amount of interactivity that the users would have.