I've create two reports in Power BI Desktop optimized for Power BI Report Server. I want to link Report1 to Report2. So, I've followed the steps in this video: https://www.youtube.com/watch?v=S-OE1T1_k3Y
I filter using a query string parameter in the URL like this: "http://localhost/reports/powerbi/Form?filter=TableA/ID eq "&'TableA'[ID]. When I test the functionality, it doesn't return the correct data in Report2.
As you can see in the URL, TableA is between single quotes. This is how it's rendered when selecting the table in DAX. I tried the URL below to see if the functionality would work but it didn't.
"http://localhost/reports/powerbi/Form?filter='TableA'/ID eq "&'TableA'[ID].
What is the syntax when filtering a table that renders between single quotes?
Go to Solution.
Maybe you have space or special character in your table name ? Can you try to rename table and field ?
View solution in original post
That was it. There were spaces in my table name and it seems the funtionality doesn't work well with table spaces. Thanks!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.