Cross Report drillthrough in Power BI Report Server

[mdubose]

Hi,

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?  

[freginier · Accepted solution]

Maybe you have space or special character in your table name ? Can you try to rename table and field ?

[mdubose]

Hi @freginier,

That was it.  There were spaces in my table name and it seems the funtionality doesn't work well with table spaces.  Thanks!