export csv to fabric lakehouse from power bi?

[JibinSebastian]

Hi All,

I want to export my filtered data in a table in my power BI report to Fabric Lakehouse?
Would that be possible? If Yes could someone help me to understand the steps to implement that. I know we have to use power automate flow but if someone can elaborate a bit that would be helpful.

any lead would appriciate.

Thanks Jibin Sebastian

[Ray_Minds]

Answer:
Power BI Desktop does not currently offer a native capability to export filtered report data directly into a Microsoft Fabric Lakehouse table. However, you can achieve similar results using an indirect pattern that leverages Power Automate to create and store a file (CSV/JSON) in a location accessible from Fabric, such as OneLake. 

Recommended Approach
Power BI → Power Automate → Fabric Lakehouse
You can use the Power Automate visual in a Power BI report to capture filtered data and generate a file that can be stored in a Lakehouse file area. This pattern enables user-initiated exports that respect the current slicer and filter context.
Implementation Pattern

1. Add a Power Automate visual to your Power BI report.
2. Include the table or fields you want exported — Power BI will pass filtered data values to the flow.
3. Build a Power Automate flow:

• Trigger: Power BI button clicked
• Create CSV table (or JSON) from the incoming data
• Create file action to save the output to OneLake / Lakehouse files

1. Validate that the file appears in the target Lakehouse location.
   This pattern effectively captures filtered data from the report and writes it into a file stored in the Lakehouse file system.
   Limitations

• Power Automate has documented limits on the size of data that can be passed from Power BI into a flow, making this solution best suited for small to medium datasets.
• This method writes data to the Files section of a Lakehouse (e.g., a folder), not directly into a Lakehouse table.
• The export is typically user-triggered via the Power BI report, not a fully automated scheduled process.

What is Not Supported

• Direct one-click “Export to Lakehouse table” from Power BI Desktop
• Automated or scheduled exports triggered solely by report refresh without user interaction 

[AshokKunwar · Accepted solution]

Hii @JibinSebastian 

​If this workflow helps you automate your data export to Fabric, please mark this as the "Accepted Solution"!

[V-yubandi-msft]

Hi @JibinSebastian ,

If you get a chance, please review the responses shared by @AshokKunwar @MFelix , as they align with your requirements. Additionally, you may also want to review the responses from other community members.

Please let us know if you need any further assistance.

Thank you all for your responses.

[cengizhanarslan]

Method: Power Automate + semantic model query

This is what most people mean when they say “export from Power BI”.

1. User clicks a button in the report

2. Button triggers a Power Automate flow

3. Flow runs a DAX query against the dataset

4. Flow saves the result as CSV into Fabric Lakehouse (OneLake)

High-level steps

1) Add a button in Power BI

• Action → Power Automate

• Create or attach a flow

2) Power Automate flow (core steps)

Step A – Trigger

• Power BI button trigger

Step B – Run query against dataset

• Action: Run a query against a dataset

• Use DAX like:

EVALUATE
FILTER (
    'FactTable',
    'FactTable'[Country] = "qwerty"
)

Step C – Create CSV

• Use Create CSV table action

Step D – Write to Fabric Lakehouse

• Use OneLake / Lakehouse file path

• Save as:

/Files/Exports/MyExport_2025-01-08.csv

[AshokKunwar]

Hii @JibinSebastian 

Power BI does not have a native "Save to Lakehouse" button within a table visual. To achieve this, we use the Power BI "Button" visual with a Power Automate trigger to pass the current filter context to a flow that writes to Fabric.

​The Solution: Power BI + Power Automate + Fabric API

​Step 1: Add the Power Automate Visual

1. ​Open your report in Power BI Desktop.
2. ​In the Visualizations pane, click the Power Automate for Power BI icon.
3. ​Drag the fields you want to export (the same ones in your table) into the Power Automate Data bucket. This ensures the flow respects your slicer selections.

​Step 2: Create the Flow

1. ​Click the three dots (...) on the visual and select Edit.
2. ​Create a new "Instant Cloud Flow."
3. ​Trigger: "On Power BI button clicked."
4. ​Action: Search for "Fabric" or "Data Factory".
   • ​Option A (Recommended): Use the "Run a Pipeline" action. This pipeline can take the data and save it as a Parquet/CSV file in your Lakehouse.
   • ​Option B (Advanced): Use the "HTTP" action to call the Fabric REST API to upload a file directly to the Lakehouse Files section.

​Step 3: Handle the Data (CSV Generation)

​Inside your Power Automate flow, add a "Create CSV table" action.

• ​Use the dynamic content from the Power BI trigger as the input.
• ​This converts the filtered rows from your report into a standard CSV format.

​Step 4: Write to Fabric Lakehouse

​Use the "Microsoft Fabric" connector (currently in preview) or an Office 365 Groups "Upload file" action if you have the Lakehouse synced via OneLake File Explorer.

• ​Folder Path: Files/Exports/
• ​File Name: Filtered_Data_@{utcNow()}.csv
• ​File Content: Output from the "Create CSV table" step.

​Best Practices & Real-World Recommendations

• ​Row Limits: Power Automate for Power BI has a limit on the number of rows it can pass (typically 1,000 to 30,000 depending on complexity). For larger datasets, trigger a Fabric Notebook instead.
• ​User Feedback: After the "Upload" step in the flow, add a "Respond to Power BI" action so the user sees a "Success" message on their screen.
• ​Security: Ensure the users clicking the button have "Contributor" access to the Fabric Lakehouse, or use a Service Principal in the Power Automate connection.

​Why this is the "Best Practice":

• ​Context Awareness: The export automatically respects whatever the user has selected in the slicers.
• ​No Manual Export: Users don't have to "Export to CSV" locally and then manually upload it; it’s a one-click process.

​Summary for the Community

​To export data to Fabric Lakehouse, use the Power Automate visual inside Power BI. This captures the filtered data, converts it to CSV, and uses the Fabric or OneLake connectors to save the file directly into your Lakehouse environment.

​If this workflow helps you automate your data export to Fabric, please mark this as the "Accepted Solution"!

[MFelix]

Hi @JibinSebastian ,

Do you want to do this from a report perspective having this available for the users at any time to do the export, or is it a one time thing or is it controlled by you?

If this is a report usage the Power Automate can make it happen, however if its not for overal report usage you should use Semantic Link Labs in a notebook in Fabric.

If you can let me know a litle bit more about the context and use case I can then go trough a better option and example.

[djurecicK2]

Hi @JibinSebastian ,

 You could try creating a shortcut in the Lakehouse from OneDrive or SharePoint folder and store the exported data in that OneDrive or SharePoint folder. Note that this is a preview feature.

https://learn.microsoft.com/en-us/fabric/onelake/create-onedrive-sharepoint-shortcut

Also, there might be better ways to accomplish your end goal than exporting from a PBI visual.