parameter url
8 TopicsPowerBi published in PowerBi report Server Direct link
Hi All, i've a lot of PowerBi (.pbix) report published in our PowerBi Report Server (not powerbi.com). Each report contains more than one sheet. Is it possible to create a direct link that allow to open directly not the default page of the report? I try using "pageName" or "ReportSection" but doesnt' work. Below some example used (not working): https://MyReportServer/reports/powerbi/MyReport?PageName=1 https://MyReportServer/reports/powerbi/MyReport?PageName=ReportSection1 https://MyReportServer/reports/powerbi/MyReport?ReportSection=1 Thanks in advance for you support, Daniele2.7KViews0likes10CommentsPut parameter to the link in Power BI server paginated report
Hello ! I am trying to fill in field wtih parameter in Power BI server. In service it works like ?rp:<some parameter>=xxx But for server it is not working. My link in Power BI server looks like http://powerbi.piece.net/Reports/report/Production/backward_traceability And I need to put only one parameter BC. Idea is to go from other report directly by creation link. Only way I found it is use ssrs link, which I can create by data feed in load menu. I belive there is more beautifull way to do it2.1KViews0likes7CommentsPassing parameters from power bi report server to SSRS RDL does not work
Hello, I'm using ?rp:parameter=value in a URL of SSRS RDL uploaded to the power bi server, But it doesn't work - the report is not filtered by the passed parameter. Is it only working with power bi service? not on server, or maybe I should use Report builder instead of SSRS to build the RDL? Thanks in advandcedSolved5.7KViews0likes12CommentsHow to pass in query paramater via URL
I have an embedded power bi report server report on a webpage. <div class="pbi-iframe"> <iframe src="http://reportserver/reports/powerbi/Sales/CustomersTest?rs:embed=true"></iframe> </div> I have created a query parameter (Cityparam) in the report which I want to pass it a value from the URL. Is it possible to pass in paramater=value in the URL for an embedded PBIRS report? I had something like this in mind: http://reportserver/reports/powerbi/Sales/CustomersTest?rs:embed=true&Cityparam='New York'Solved879Views0likes1CommentFilter a directQuery with parameter and apply parameter change within URL call (PBIRS sept2021)
Hello all, I try to accomplish a very simple task: have a pbi installed on my PBIRS on premise that is able to "direct query" with filter parameter. I have a table USER and want to apply the filter when the query run. All works fine in PowerBI Desktop (optimized for PBIRS Sept2021), when I change the parametre value in "manage parameter" the query is correctly filtered. When I publish the pbi on PBIRS and call it with a filter parameter : xxx/powerbi/DirectQueryParam?USER_PARAM=3 The pbi always return the row filtered in PowerBi Desktop (USER 1), I'am unable to override the parameter whit the URL call. DirectQueryParam is the name of the pbi USER_PARAM is the parameter Here the query: let Source = Sql.Database("server", "database", [Query="SELECT "&Number.ToText(USER_PARAM)&" PARAM, ID_USER, ID_PROFIL FROM USER where ID_USER ="&Number.ToText(USER_PARAM)&"", MultiSubnetFailover=true]) in SourceSolved6.1KViews0likes4CommentsAdd filter to URL by a uniqueidentifier field type
Hello I've tried to add a filter to a report url for a field type uniqueidentifier like this: ?filter=[table name]/[field name] eq '[uniqueidentifier value]' ,but unfortunately it doesn't work. Is there any other way to filter a url? Or alternatively is there another way to pass a parameter value to a report parameter on a report server? Thank youSolved2.1KViews0likes2CommentsAttempting to Pass a parameter through a URL in Power BI Report Server August 2018 version
Version of PBIRS - Version 1.3.6816.37243 (August 2018) Prepared my URL as I thought I should http://<REDACTED PBIRS SERVER>/Report Folder/Report Name?filter=Spreadsheet Query/Status eq 'Open' Translates to: http://<REDACTED PBIRS SERVER>/TEST/test%20shark?filter=Spreadsheet%20Query%2FStatus%20eq%20Open Spreadsheet Query is the name of the table (data source folder) Status is the name of the field Status shows up in the Filters window Status is also a slicer that is visible Report Executes in PBIRS but returns all values, not just the 'Open' ones Tried with and without the name of the data source folder, same results. Data Source Storage Mode is Import Thoughts?716Views0likes0Comments