How to Export Power BI Data to Excel | Query against a dataset
Power BI
Apr 24, 2023 12:30 PM

How to Export Power BI Data to Excel | Query against a dataset

by HubSite 365 about Reza Dorrani

Principal Program Manager at Microsoft Power CAT Team | Power Platform Content Creator

Data AnalyticsPower BIPower SelectionM365 Hot News

Do you want to export your Power BI report data to Excel or CSV file? In this video, we will explore multiple options on export to excel from Power BI data

Do you want to export your Power BI report data to Excel or CSV file?

In this video, we will explore multiple options on export to excel from Power BI data with a button.

We will take advantage of the Power Automate Visual in Power BI to send data to flow, flow can create the CSV or Excel file and export it to a data source of our choice like SharePoint. I will also showcase how to directly perform a query against a Power BI dataset in Power Automate flow, which directly performs a Power BI REST API to run the query to get large data (There is a limit of 100,000 rows on this API).

The Power Automate flow visual can export your data to excel using a button in Power BI but there is a 1000 row limit. If using the “perform a query against a Power BI dataset” flow action, you can export up to 100,000 rows per query!

I will also showcase a simple way to get DAX Query using the Performance Analyzer feature in Power BI desktop.

Table of Contents:

  • 00:00 - Introduction on How to Export Power BI Data to Excel or CSV
  • 00:36 - Power BI Report - Export Data button using Power Automate flow Visual
  • 02:06 - Export to CSV button flow from Power BI Report
  • 05:53 - How to export Power BI data to an Excel file
  • 10:41 - Share the export to Power BI flows
  • 11:16 - 1000 row limit with Power Automate flow Visual in Power BI
  • 11:51 - Export large data from Power BI to excel or CSV
  • 15:20 - Run export excel flow from Power BI based on many trigger options
  • 15:52 - Run a dynamic DAX query against a Power BI dataset in Power Automate
  • flows
  • 17:50 - Subscribe to Reza Dorrani channel

Hover your mouse over the tile or visualization in question. · You'll see an ellipsis (…) in the upper-right corner. · From the ellipsis dropdown, choose Export ...

Feb 23, 2023 — Feb 23, 2023In this article, we'll show you the step-by-step process in exporting Power BI data to Excel. We'll also include an old-school copy-paste ...

Dec 7, 2022 — Dec 7, 2022Export data from a report · Select the visual, select More options (...) > Export data. · In the Save As dialog box, select a location for the .

Export data from a Power BI to Excel with “Export Data” · Go to app.powerbi.com and select a report to which you have access. · Click the “…” button in the top ...

Jun 5, 2022 — Jun 5, 2022Go to the Excel “Data” tab and select “Get Data” · Choose “From Power BI” in the drop-down menu · Select a dataset from the right-hand pane to ...