Forum Discussion

dee15678's avatar
dee15678
New Member
3 years ago

Power BI report to show data with query string filter else empty

Hi

 

I have a report with data which should be visible to users when query string filter is provided in the url. If the user gets to the report without query string filter, they should see a blank report.

 

How to achieve this?

 

thanks

Need Help

1 Reply

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    3 years ago

    You need to prefilter the report to show nothing. However, this is not security. They can override the filters. The only true security of data in Power BI is through Row Level Security. Don't rely on URL filters. Those are for convenience, not security. Row-level security (RLS) with Power BI - Power BI | Microsoft Learn


    There is also something called Object Level Security that is very secure as well, but it isn't necessary most of the time and has implications RLS above doesn't. RLS is usually the way to go.