Forum Discussion
Helper IPassing parameters from power bi report server to SSRS RDL does not work
It does not matter what tool you use to author the rdl files. The issue is that Report Server uses the Reporting Services syntax for passing parameters via the URL which is slightly different to the Power BI service syntax. If you remove the rp: prefix your urls should work (see https://docs.microsoft.com/en-us/sql/reporting-services/pass-a-report-parameter-within-a-url?view=sql-server-ver15 )
OK found the problem...wrote "False" instead of False()
I'm new to DAX so learning the hard way I guess...
Super User
pbiuser1234 wrote:
1. Is there a way to shoten the URL?
Not really, other than doing in IF in your code.
pbiuser1234 wrote:
2. I'm trying to write a DAX code to return URL with no filters if no selections were made,
If you leave the parameter empty then Report Server will want to prompt the user for the parameter value. One option is to have a special value like "<ALL>" to return all the values, but you would have to add logic in your report query to cater for this or configure your report query as an expression. It depends on how you are dealing the multiple values in your report query as to how the logic should be adjusted.
Helper IHi again:)
I didn't leave the parameter empty, this is the code:
if( ISFILTERED(Query1[Employee])="True", _result_filterd, _result_all )
Why do I get an error for this code?
Thanks
- pbiuser1234
OK found the problem...wrote "False" instead of False()
I'm new to DAX so learning the hard way I guess...