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: 1. Retrieve data from the lakehouse. 2. Generate a report or dataset as an Excel file. 3. Reply to the original email with the report attached using Microsoft Graph. 4. 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

I have multiple pipelines in Fabric. Some copy databases (like PostgreSQL) into the warehouse, while others run notebooks and collect data from APIs and Firebase into Fabric. Right now, I only receive a simple email notifying me that something went wrong, but I need to open the pipeline manually to check the error details. What I want is: - To automatically send an email with the log file or detailed error message when a pipeline fails. - To send this email in HTML format so it’s easier to read. How can I configure this in Fabric? Is there a built-in way ? Any guidance would be greatly appreciated!

Hi all, I’m building a Power BI dashboard in Microsoft Fabric using a Lakehouse as the source. When I click "Create report" from the Lakehouse, I can only see the tables, not the views I’ve created. Also, I’m unable to create new measures or calculated columns within the report. My goal is to build visualizations based on views, not just raw tables. Is there a way to enable views in the Lakehouse UI or make them accessible in Power BI for reporting? Also, is it expected that measure creation is disabled in this context? Appreciate any help or clarification. Thank you!

Hello everyone, I'm new to Microsoft Fabric and currently working on data pipelines that copy data from a PostgreSQL database to a Fabric warehouse. The data copies successfully, but I noticed that primary keys and foreign key relationships are not transferred to the warehouse tables. All the tables are created, but the relationships between them are missing. (over 550 tables) Is this the expected behavior? Is there a way to preserve or automatically recreate the primary/foreign keys during or after the pipeline execution? Any advice or best practices would be appreciated. Thanks!