Dynamic Filtering not working with new table visualization

[Mbuczynski]

I have a dynamic filter on a table that link to a different report. When I changed the table to the new table visual the links go to the correct report but do not filter even though the filter data is passed into the url correctly. Anyone else having this issue? I was able to validate this as the root cause by using an older version of the file with everything else the same except for the visual type was the old static table.

[v-jiascu-msft]

Hi @Mbuczynski,

Could you please provide more information?

What kind of URL and link here? (maybe you are using Power BI embedded.)

Maybe these two posts could help:

Passing-parameters-to-the-report-URL

https://www.youtube.com/watch?v=nfkVljh_9O4&feature=youtu.be

Best Regards!

Dale

[Mbuczynski]

@v-jiascu-msft - This is on a published report in the power bi service. I used the dynamic filtering technique listed in the guy in a cube video linked below. It was working until I changed the table to the new table format (the one that can be clicked and used as a filter) included with July's release. 

https://www.youtube.com/watch?v=EXObcA9G9Vw

[v-jiascu-msft]

Hi @Mbuczynski,

There is a workaround for now. Just for now, I am going to submit an report internally and I will post here as soon as I get response.

The workaround is: create the url, then paste it in the browser. Finally we will get a new url. Use this new url in the report. 

Thank you for your understanding and patience.

Best Regards!

Dale

[Mbuczynski]

@v-jiascu-msft - Thank you for the response Dale, and thank you for escalting to the team. 

Unfortunately, that work around will not work for us. We have a dynamic set of data that we are using to pass through to the filter and I cannot manually update that each day. At this time the links will remain broken. 

[v-haibl-msft · Accepted solution]

@Mbuczynski

ETA is between 08/16 and 08/21 for Power BI Service.

The fix will appear on Sep 2017 version of Power BI Desktop (Usually first week of September).

A workaround is to replace any space in the data with %20

This can be done using a calculated column as

Url2 = SUBSTITUTE(Table1[URL], " ", "%20")  

Best Regards,
Herbert

[Mbuczynski]

@v-haibl-msft - Excellent. Thank you for your help. Looking forward to the fix. In the meantime, the workaround provided works great.