Automating email-based reporting with Fabric and Microsoft Graph

Hi,

I’m working on a project where colleagues can send an email to a bot address. When the bot email receives a message (based on the subject line), it should:

Retrieve data from the lakehouse.
Generate a report or dataset as an Excel file.
Reply to the original email with the report attached using Microsoft Graph.
Additionally, send scheduled weekly reports to specific recipients.

My idea is to implement this in Fabric using a notebook, running every 15 minutes to check for new emails, query the data via GraphQL in Fabric, and then send the results.

My questions are:

Is this approach feasible in Fabric notebooks?
Regarding GraphQL authentication: when I run it locally, it opens a browser for login. Is it possible to use a token instead, and if so, how should I configure it so that it works automatically in Fabric?

thank youu

1 comment