Publish to web option : filtering the report ?

[quentin_vigne]

Hi everyone,

I have a report that contains a list of my clients. At the moment, the report is used to see some clients, group of clients but only by the company members.

I would like to publish to web my report to embed it in private web site where client have their own private access. 

I would like the client to only see their data and not other clients datas.

Is it possible to apply a filter to my report, like instead of choosing one client in my dropdown list, the client account would be choose according to the ID of connexion they are using to access the web page ?

Thanks in advance,

Quentin

[arelmagayon]

This is possible on POWER BI online (I don't how it is called), using this format:

?filter=<table>/<column name> eq '<your value filter>'

Add the code at the end of the url

But these seems not to work on embedded url which is I think the point of the question and this is also what I'm trying to do and if this is followed you'll just get an error. See text below.

This content isn't available.
Learn more about Power BI.

[Anonymous]

Hi @quentin_vigne

Can you share a dummy data and explain the problem?

[quentin_vigne]

I cannot share real name as my clients are private but it looks like that : 

IdClientCpte;Libelle
1;Client1
2;Client2
3;Client3
4;Client4
5;Client5
6;Client6
7;Client7
8;Client8
9;Client9
10;Client10

I have a website where my client have and login and password and can have access to their files they have. What I would like is to embedd my PBI report and only display value for the client concerned

For example Client1 has 3 files with me, I would like that when he's on his account on my website he only see his account name on my report and only his 3 files, not other client files.

[quentin_vigne]

@Anonymous 

Any help ? 

[Anonymous]

I dont think this will be possible to achieve by PowerBI Embedding. One solution I can think of is building different reports for each client and keeping them in separate workspaces. You can then allow them to access reports by their "WorkspaceID".

[quentin_vigne]

@Anonymous

This is not possible, because I would have to make more than 1000 reports ...

[Anonymous]

Have you tried using Row Level Security? I am not sure if it will address your issue, but you can look into it here : 

RLS in Power BI

[quentin_vigne · Accepted solution]

After some research I've found that the option is not yet available. (For example filtering with url or something else than UPN)