Forum Discussion

Vishal_PBI's avatar
Vishal_PBI
Frequent Visitor
8 years ago
Solved

filter by parameter in web published report

Hi All,   End goal is to Restrict user to see their report only in web.   I have a report which consist 100s of user and adding new users every week, currently I am creating report for each user ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Vishal_PBI,

 

If you reports are share with 'publish to web' feature, current it not support any security settings and url filters.

 

Limitations and troubleshooting

There are a couple of things to be aware of when using the query string parameters.

  • Query string filtering does not work with Publish to web or Power BI Embedded.
  • Field type has to be number or string.
  • Table and field names cannot have any spaces.

 

I'd like to suggest to use power bi embedded with dynamic RLS to instead.

 

Power bi embedded:

Official Documentation – Power BI Embedded

GitHub Sample Repo

 

RLS:

Power BI – Dynamic Row Level Security – Tips to get it working!

RLS with UserName()

 

Regards,

Xiaoxin Sheng

  • Vishal_PBI's avatar
    Vishal_PBI
    Frequent Visitor
    8 years ago

    HI Xiaoxin Sheng,

     

    Thanks for your help, I am working on it. hope it works for me.

     

    Thanks!