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 UserIt 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 )
pbiuser1234WOW Amazing!! Thank you so much it works great now with one value passed in the url,
If I need multiple values, is there a way in DAX syntax for some kind of loop? If so do you have an example?
I need to pass multiple values for the parameter "Emloyee" like this:
https://ReportServer/Reports/ReportName?Employee=1&Employee=2
This is my code that works for one value:PaginatedaReportURL =
var _baseurl = "https://ReportServer/reports/ReportName"
var _selectemployee = SELECTEDVALUE(Query1[Employee])
var _reportparameterEmployee = "?Employee="&_selectemployee
var _result = _baseurl&_reportparameterEmployee
return
_result
Also I want the rdl to open up automaticly in excel so I've added "&rdl:format=excel" to the URL - but this also doesn't work (also tried "&rs:Format=excel" or "&Format=excel"). Maybe syntax also should be different for the server version?Thanks a lot!- d_gosbell
pbiuser1234 wrote:
If I need multiple values, is there a way in DAX syntax for some kind of loop?
Yes, you could use the CONCATENATEX function
PaginatedaReportURL =
var _baseurl = "https://ReportServer/reports/ReportName"
var _selectemployee = CONCATENATEX(VALUES(Query1[Employee]), "&Employee=")
var _reportparameterEmployee = "?Employee="&_selectemployee
var _result = _baseurl&_reportparameterEmployee
return
_result
pbiuser1234 wrote:
Also I want the rdl to open up automaticly in excel so I've added "&rdl:format=excel" to the URL - but this also doesn't work (also tried "&rs:Format=excel" or "&Format=excel"). Maybe syntax also should be different for the server version?The "rs:Format=EXCEL" should get you an xls file, if you use "rs:Format=EXCELOPENXML" it will return an xlsx file. (see https://docs.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-server-ver15 ) - I don't think the upper/lower case matters
- pbiuser1234
Thanks for the reply,
About opening an excel file, I tried this code but it doesn't work:
https://<ServerName>/<Reports>/report/<ReportFolderName>/<ReportName>?rs:format=excel
If I change the question mark location anywhere before folder name - it leads me to the folder root. for example:
https://<ServerName>/<Reports>/report/<ReportFolderName>?/<ReportName>&rs:format=excel
What am I doing worong?
I have to say that "rs:embed=true" works fine written like this:
https://<ServerName>/<Reports>/report/<ReportFolderName>/<ReportName>?rs:embed=true
Thanks again