Forum Discussion
persianharry
Sep 17, 2020Copper Contributor
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 event...
Command0r
Sep 17, 2020Iron Contributor
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.