Sharing data progress outside Fabric Notebook

Current workflow is:

Read Lakehouse table into a Spark datafram in a Notebook

Run any analysis (e.g. a ProfileReport from ydata_profiler package)

Write the profile report to an html file in the Lakehouse

Use OneLake file explorer in windows explorer to view the html file in a browser (requires installing OneLake file explorer (https://learn.microsoft.com/en-us/fabric/onelake/onelake-file-explorer))

Kinda works for now

Yeah, so the best move is probs exporting your notebook output to OneDrive or Azure Blob Storage and just sharing access from there. You can also save stuff as CSV or Parquet files and plug it into Power BI or whatever dashboard tool you like. Fabric doesn’t let you share live notebook progress yet (rip), but this workaround works fine. Honestly, hoping Microsoft adds a built-in way to share soon would make life way easier for collabs and updates. You can also visit my website.

Yeah, so the best move is probs exporting your notebook output to OneDrive or Azure Blob Storage and just sharing access from there. You can also save stuff as CSV or Parquet files and plug it into Power BI or whatever dashboard tool you like. Fabric doesn’t let you share live notebook progress yet (rip), but this workaround works fine. Honestly, hoping Microsoft adds a built-in way to share soon would make life way easier for collabs and updates. You can also visit my website.

Hello data_quantum 

If you have access to Databricks, which is a first-party Microsoft offering, you can use Databricks Apps to host a Streamlit/Dash/Flask app that can connect to your Fabric Lakehouse SQL endpoint.

Here's the link to Microsoft docs

Key concepts in Databricks Apps - Azure Databricks | Microsoft Learn

Hope this helps - please appreciate by leaving a Kudos or accepting it as a Solution to help others! 

What Doesn’t Work Well

• PDFs: Static, not suitable for interactive profiling reports.
• Power BI: Powerful but often overkill for quick sharing, and adds friction.
• Streamlit inside Fabric: Not currently supported natively within Fabric notebooks due to environment limitations.

Best Ways to Share Interactive Reports Outside Fabric

1. Export Data + Host Streamlit Locally

Since Streamlit doesn’t run inside Fabric, you can:

• Export your processed data (e.g. as CSV or Parquet) from the notebook.
• Build a local Streamlit app on your laptop using ydata-profiling or pandas-profiling.
• Share the app via:

• Internal web server (e.g. localhost or intranet)
• Streamlit Cloud (for public or semi-private sharing)
• Docker container (for reproducibility)

This gives you full interactivity and control.

2. Use HTML Export from Profiling Tools

If you're using ydata-profiling, you can export the report as an HTML file:

profile = ProfileReport(df) profile.to_file("report.html")

Then share the HTML file via email, Teams, or a shared drive. It’s interactive and lightweight—no need for Streamlit.

3. Fabric + OneLake + External App

• Store the processed data in OneLake.
• Build a lightweight web app (Streamlit, Dash, Flask) outside Fabric that reads from OneLake.
• This separates compute from presentation and avoids tying the report to your notebook session.

Hi data_quantum,

That's an interesting question and one that many data science teams encounter when moving from experimentation to stakeholder communication.

While Fabric Notebooks are excellent for development and analysis, they're not always the most convenient way to share interactive outputs with business users. A common approach is to save analysis results or HTML reports (such as profiling reports) to OneLake and then share them through an appropriate delivery mechanism, depending on the audience. This keeps the notebook focused on development while making outputs more accessible.

Another option is to package reusable analyses into applications or services outside the notebook environment when business users need a more interactive experience. As Microsoft Fabric continues to evolve, it will be interesting to see even tighter integration for sharing interactive notebook outputs directly with non-technical stakeholders.

Thank you for raising this topic. It highlights an important aspect of the data science lifecycle—bridging the gap between technical analysis and business collaboration.

Hi data_quantum,

Fabric Notebooks are mainly designed for analysis and development, so they are not always the easiest interface for sharing interactive results directly with business users.

For a ydata-profiling report, one practical option is to export it as an interactive HTML file:

from ydata_profiling import ProfileReport

profile = ProfileReport(df)
profile.to_file("/lakehouse/default/Files/profile_report.html")

The HTML report keeps most of the interactivity and can then be downloaded from the Lakehouse and shared through Teams, SharePoint, OneDrive, or another internal location.

For a more reusable solution, a common architecture is:

Fabric Notebook → OneLake/Lakehouse → External application

The notebook performs the analysis and stores the processed data or report output in OneLake. A lightweight application built with Streamlit, Dash, Flask, or another web framework can then read that output and present it to stakeholders.

Streamlit generally needs to run in a separate application-hosting environment rather than directly inside the Fabric Notebook session. Separating the analytics layer from the presentation layer also makes the solution easier to maintain and scale.

For quick sharing, the HTML export is usually the simplest option. For recurring stakeholder access, an external web application connected to OneLake is the better long-term approach.