topic Re: URL FIlter + SSAS in Report Server

URL FIlter + SSAS

dmt — Fri, 11 May 2018 11:17:46 GMT

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?

Re: URL FIlter + SSAS

Anonymous — Fri, 11 May 2018 12:05:41 GMT

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?

Re: URL FIlter + SSAS

dmt — Fri, 11 May 2018 12:22:35 GMT

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.

Re: URL FIlter + SSAS

Anonymous — Fri, 11 May 2018 12:28:09 GMT

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%2746%27

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