URL FIlter + SSAS

[dmt]

Hi, i'm using Power BI Report Server (march 2018).

Filter on https://bi.mycompany.com/reports/powerbi/Dashboard/TFS/TestFilter?filter=ID eq '46' not working.

It's supported? In my cube, dimensions name with spaces, how to be?

[jcollinson2001]

Hi,

I got URL filters working on my SSAS tabular model this morning.

I'm not sure if there are any differences between multidimensional models and tabular models, but one thing which stands out in your URL is "ID eq '46'". With our model, I had to include the table before the field name - e.g. "Specialty/ID eq '46'".

Does this apply to your scenario?

[dmt]

In my case there are no tables, there is only dimension and measure.
Dimension contains a space in the name, tried to specify - without result.

[jcollinson2001]

Ahh - so just to confirm, you tried:

https://bi.mycompany.com/reports/powerbi/Dashboard/TFS/TestFilter?filter=Work Item/ID eq '46'

It may be worth trying to URL encoded equivelant:

https://bi.mycompany.com/reports/powerbi/Dashboard/TFS/TestFilter?filter=Work%20Item%2FID%20eq%20%27...

Sorry I couldn't help further! Anyone else got any ideas?.