Forum Discussion
Best method for generating reports from Azure SQL Server and emailing them?
I'm getting confused with all the Azure options and renaming of services, could someone offer advice on the best method to do this:
From data in a SQL Server database, certain data triggers events that will necessitate emails sent to people (outside of azure) with a simple, but formatted, data report embedded in the email and some dynamic text. I could have a number of different report formats to choose from depending on the data that caused the event.
Thanks.
This is something that can be achieved with the Power Automate platform + PowerBI. I'd offer you to investigate the following:
- Use PowerBI to create simple reports
- Use Power Automate (Microsoft Flow) to use an existing template(s) or construct your own with a huge set of predefined building blocks. This is something you can use as a good example: https://flow.microsoft.com/en-us/galleries/public/templates/8263a2d1fc9444a2aa8012474ecb32f4/add-row-in-sql-server-when-an-alert-is-triggered-in-power-bi-and-send-email/
Both items are part of O365. Should be easy enough to achieve your goal.
