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 filter...
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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for this, 

 

Is there then a way to automatically send the link daily to the users via email if their is data against their name so they can easily check this?

 

Thanks a lot 

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi Anonymous 
You can create a dashboard top of the report and then you can use Data Alert 
Find the article - https://learn.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

Or 
Use Power Automate to send alert to users (when data cross the limit or their are data for users)
In Power Automate, Power Bi connectors or email connetors are free to use if you and users have Power BI Pro license.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-flow-integration 
Please search Youtube video for same, there are many video available

If solve your question, mark as SOLUTION. Appreciate your KUDOS 👍

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks a lot, 

     

    Is there a way to create an alert based on a column in a table view ?

    • PijushRoy's avatar
      PijushRoy
      Community Champion
      2 years ago

      Hi Anonymous 

      Please use Power Automate

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thanks 🙂

         

        For Power Automate is there a way to get the email list of users from the table itself?

         

        As the Users change daily