topic Re: How to let user enters value in PBIRS in Report Server

How to let user enters value in PBIRS

Anonymous — Mon, 21 Oct 2019 20:58:53 GMT

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

Re: How to let user enters value in PBIRS

ali_a — Sun, 27 Oct 2019 19:49:21 GMT

I'm still looking for help?

Re: How to let user enters value in PBIRS

d_gosbell — Mon, 28 Oct 2019 01:38:46 GMT

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.

Re: How to let user enters value in PBIRS

Anonymous — Thu, 31 Oct 2019 05:04:59 GMT

Hi d_gosbell

I tried the paginated but not working with me. I'm still looking for another way to solve this. 😞