Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dynamic Report link in email with filters

Hi all, 

 

I have a power bi report which is a table view of data. In this I have two columns the Division and User, 

 

I would like to send a daily email a link of the report to each user filtered for just their data.

 

I would like to send a weekly email a link of the report to each Division lead.

 

Is there a dynamic way to do this, so I only dont have to create a link for each user as they will change depending on the data in the report.

 

Thanks, 

Interesting Links
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    Firstly, if you want to restrict the data based on user, you can try dynamic rls in Power BI.

    For reference: Dynamic Row Level Security with Power BI Made Simple

    Then you can configure email subscriptions for your report in Power BI Service. 

    Subscribe yourself and others to Power BI reports, dashboards, and paginated reports. You receive an email on a schedule you set. The email contains a snapshot and link to the report or dashboard or a full attachment of the report or dashboard. 

    For reference: 

    Email subscriptions for reports and dashboards in the Power BI service

     

    Best Regards,
    Rico Zhou

     

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

8 Replies