Forum Discussion

dyungaitis's avatar
dyungaitis
Frequent Visitor
4 years ago
Solved

How to restrict access by filter value in published report

I have a heavy report that runs every 15 minutes.  We want to share this data with outside organizations but only want them to be able to see their group's data.  I really don't want to create and ma...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi dyungaitis ,

     

    To view the shared reports, conditions are required.
    The viewer needs to be a Power BI Pro account, or the shared report is hosted in Premium Capacity. Please note that free users cannot view reports with RLS.

     

    Since you need to publish the report to the web, neither Query string parameters in the URL nor RLS are supported.
    As far as I know, I'm afraid your requirement cannot be implemented in Power BI at this stage.

     

    Best Regards,
    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi dyungaitis ,

 

Is the URL filter you are trying to use the one mentioned in this article below?

Filter a report using query string parameters in the URL 


If you are going to have five reports for different users, you need to set up five different URLs for each.

If it doesn't work I still recommend using RLS, that's the best I can think of.

You can log into the azure portal using your power bi account: https ://portal.azure.com/  . Then click Azure Active Directory->Users->New User to add the external account to your organization. Then try RLS again.

 

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

dyungaitis's avatar
dyungaitis
Frequent Visitor
4 years ago

Unfortunately this doesn't work for me.  Query string parameters in the URL are what I am looking for, but don't work for "publish to web" reports which is what I am trying.

Does RLS require the other party to have a Power BI license on their side?  I can't test it with my personal email because it says it isn't a work email.  Do they have to buy a license or can I assign it to their account from my side?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi dyungaitis ,

     

    To view the shared reports, conditions are required.
    The viewer needs to be a Power BI Pro account, or the shared report is hosted in Premium Capacity. Please note that free users cannot view reports with RLS.

     

    Since you need to publish the report to the web, neither Query string parameters in the URL nor RLS are supported.
    As far as I know, I'm afraid your requirement cannot be implemented in Power BI at this stage.

     

    Best Regards,
    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

    • dyungaitis's avatar
      dyungaitis
      Frequent Visitor
      4 years ago

      Hi.  I'm not sure why you marked your response as the solution because nothing you provided me actually helps solve my problem.