Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI Notification System

Can anyone please help me to create a notification system so that whenever user uploads a file in OneDrive and Power BI gets the data through schedule, power BI sends a email to the user along with the pdf version of data captured by Power BI

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi blopez11 ,

      Thanks for the quick reply

      The files are getting uploaded on OneDrive once a week, and different units are uploading it at different times. Now I have been asked to create a system which will send the email only to the unit who has uploaded the data and the email should contain a pdf version of the visual based on the data uploaded and nothing else.

      Can you please guide me how can I create subscription in this scenario

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous Sounds like a Power Automate thing. Has hooks for all of those things.

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi， Anonymous 

    Here is a  tutorial of using the new refresh a dataset action to automate refreshing a Power BI report based on changes to a SharePoint list or updates to an Excel file in OneDrive or SharePoint Online.As mentioned in this tutorial,it have added a new Refresh a dataset action to the Power BI connector for Microsoft Flow. It will be able to trigger dataset refreshes based on hundreds of Flow triggers. 

     

    While it is not supported to automatically send PDF export of refreshed report email in in Power BI currently unless the report is a Paginated Report.Someone told restApI can be helpful.I have not tested it.

    You aslo  can vote for  this related idea.

     Scheduling the dashboard reports into shared location or email by exporting into pdf/excel

     

    Best Regards,
    Community Support Team _ Eason