Hello PBI Experts,
I'm using Power BI Desktop to create a report, which has 3 tables. the report displays data from the 3 tables. there is a common field that appears in all 3 tables, and there are relationships between these tables as well on that same field.
I use "Import" in my data connectivity mode, which brings the data to PBI using a un-filtered sql statement from SQL Server.
My goal is to have a Url Link to the report on PBI Service (app.powerbi.com) that filters out the report based on this url query parameter that I have, and that filter to be applied to 3 different tables that construct the report data display.
Here is how it is setup right now: I have 3 report filters, one field for each one of my tables. In order to display the report correctly in PBI Desktop, it works correctly by setting up the report filter value for each one of them. But right before I publish, I remove these values so the report is not filtered (but I keep the 3 report filters), I publish the report to web. Now to access it by url, I use the schema (special characters are encoded):
https://app.powerbi.com/groups/me/reports/[reportid]/ReportSection1?filter=[table name1]/[column name1] eq '[value]'
But this only filters one single Report filter in Table 1, but I need to filter the remaining 2 report filters as well from this URL.
I tried to pass 2 more filters in the url, in a way similar to:
https://app.powerbi.com/groups/me/reports/[reportid]/ReportSection1?filter=[table name1]/[column name1] eq '[value]'&filter=[table name2]/[column name2] eq '[value]'&filter=[table name3]/[column name3] eq '[value]'
But the url gets redirect to the original form which only shows one query string parameter as in:
https://app.powerbi.com/groups/me/reports/[reportid]/ReportSection1?filter=[table name1]/[column name1] eq '[value]'
Also, in the query editor, I made sure that the fields is of Type Text in the 3 tables.
I'm cannot use PBI Embbeded at this point so that route is blocked. And also I do not want the user to do any slicing / filtering from the UI, I want the user to open the url, view the report with pre-set filters, and that is it, there is no user interaction with the report , other than printing.
I'm not sure if I'm missing something, or if it is a feature that is in development.
thanks!
