Best method for generating reports from Azure SQL Server and emailing them?

%3CLINGO-SUB%20id%3D%22lingo-sub-1676576%22%20slang%3D%22en-US%22%3EBest%20method%20for%20generating%20reports%20from%20Azure%20SQL%20Server%20and%20emailing%20them%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676576%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20getting%20confused%20with%20all%20the%20Azure%20options%20and%20renaming%20of%20services%2C%20could%20someone%20offer%20advice%20on%20the%20best%20method%20to%20do%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20data%20in%20a%20SQL%20Server%20database%2C%20certain%20data%20triggers%20events%20that%20will%20necessitate%20emails%20sent%20to%20people%20(outside%20of%20azure)%20with%20a%20simple%2C%20but%20formatted%2C%20data%20report%20embedded%20in%20the%20email%20and%20some%20dynamic%20text.%20I%20could%20have%20a%20number%20of%20different%20report%20formats%20to%20choose%20from%20depending%20on%20the%20data%20that%20caused%20the%20event.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1676576%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.

1 Reply

@persianharry 

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

Both items are part of O365. Should be easy enough to achieve your goal.