Web URL Query String reaching browser character limits? others ways to pass parameters?

[al12397]

Hey All,

I have 2 dashboards. One in which is my Main dashboard with summarized Data and the other is a direct query dashboard with larger dataset. From there I give an option to Users to look at the larger dataset via a weburl in which I pass filters (something like "https://reportingserver.net/Reports/powerbi/exampledashboard&filter=table%2Fcolumn1%20in%20('parameter')") from my "Main" dashboard  . In same instances based on the Value users selects my Query String exceeds the charecter limits set by the different browsers becasue of a lot of paramerters. My question - Is there another way to pass parameters onto a different dashboard in the Reporting Server?maybe instead of a weburl something like passing sql query? Is there a way to solve my Web Url Query String problem without significantly reducing user selections?

[Anonymous]

HI @al12397,

For your scenario, it is impossible to send other types of parameters/filters from the url query string.
If you setting up query parameter and apply it with your power query table connector function, it is possible to post the t-sql string to database side. (notice: they not able to interact with URL query strings)

Regards,

Xiaoxin Sheng

[al12397]

Hey,

@Anonymous Can you explain more in detail this approach, How does it work, How do I set it up and will it work with only end users making selections drilling down etc?

[Anonymous · Accepted solution]

Hi @al12397,

>>Can you explain more in detail this approach

In fact, the URL filters that you mentioned not able to interact with other types of filters.

Filter a report using query string parameters in the URL 

So if you want to change the t-sql that applies to your data source, I'd like to suggest you create a query parameter that stored these query string and uses it in the query option of SQL connector. 

After you publish your report to power bi service, you can also modify this query parameter to change the backend query table. (notice: you need to keep the result similar to previous table structures or it will return an error to processing the query table steps)

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev 

Edit parameter settings in the Power BI service 

If you share permission to end users, he also able to do the similar things that I mentioned above.

Regards,

Xiaoxin Sheng

[lbendlin]

Are these filters predictable (ie the users always seems to use the same set of fields etc) or random (no discernable pattern?).  If the former then you might be able to create different reports that better cater to the users' preferred focus.