Forum Discussion

mdubose's avatar
mdubose
Icon for Helper I rankHelper I
3 years ago
Solved

Cross Report drillthrough in Power BI Report Server

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?  

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

2 Replies

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

    • mdubose's avatar
      mdubose
      Icon for Helper I rankHelper I

      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!