Pass URL filters service - not always works?

[Anonymous]

Hi community, 

I am trying to filter a report in the service with URL filters. However it does not seem to be working as expected. 

I am following the almighty documentation https://docs.microsoft.com/en-us/power-bi/service-url-filters 

.... It works with imported datasets, direct query to SQL databases, HOWEVER - i am strugling to figure out why it does not work with direct connection to Analysis Services (on prem) - multidimensional cube... 

Filter argument should look like this (correct me if I am wrong here):

?filter=00_x0020_Table/Column eq 'FILTER'

For a table with name:

00 Table/Column    

Anyone had similar issues with directQuery to multidimensional? 

[v-juanli-msft]

Hi @Anonymous

Does the video provide some ideas for you?

Is your problem sloved? if solved, could you share with us so it may help others?

If not, please don't hesitate to ask me.

Best Reagrds

Maggie

[Anonymous]

hi,

sorry for late response on this. The video does not sort the problem. I have generated the link as per documentation, however table names has some non-ascii characters. I created the link with _x...._ rules instead of those characters. 

I have a few ideas why this might not work, but I am not sure:

Two non-ascii characters in the table name: 

So my table name goes like this : "01 Name -Source"  and column name is "Operation Level 1" 

so my filter argument in URL looks like this (after initial link to report, as per documentation):

?filter=04_x0020_Name_x0020__x002D_Source/Operation_x0020_Level_x0020_1 eq 'MyValue'

The place in red - will it pass this to the web service as " -" ?? 

Also another question - if the filter argument (indicated as MyValue) has whitespaces do I need to insert the code with _x..._ syntax? 

[v-juanli-msft]

Hi @Anonymous

Does my reply help you? 

Best Reagrds

Maggie

[v-juanli-msft]

Hi @Anonymous

It is possible to pass URL filters in ssas live connection, Check out this Guy in a Cube video for a walthrough on how to do this

https://www.youtube.com/watch?v=ywaTxQKchx8&t=108s

regarding your parameter, please see the following picture, it seems your parameter a bit different from it. we should note that 

'FILTER' should be a value in the column of table in your parameter

Best Regards

Maggie