Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
lmireland
New Member

Data hub - download list of datasets

Hi

 

is there a way to download the list of datasets to excel or something similiar?

 

ie like this 

 

name type        owner location refreshed endorsement sensitivity

ds1     dataset   m1      ws1        2/3/2023

ds2     dataset   m1      ws2        2/3/2023

etc

 

Lm

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi  @lmireland ,

In Power BI Desktop, you can choose between the following two ways.

1. Cope table - copy directly to Excel afterwards

vyangliumsft_0-1678067732649.png

2. Export table in Visual.

vyangliumsft_0-1678067779503.png

 

In Power BI Servcie, you can choose between the following two ways.

1. Export data from a Power BI visual to Excel with “Export Data”

vyangliumsft_2-1678067732655.png

2. Export large data sets from Power BI to Excel with “Analyze in Excel”

vyangliumsft_1-1678067801030.png

 

Both "Export data" and "Analyze in Excel" have restrictions on their use, you can check the following links::

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d...

Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn

https://www.datacamp.com/blog/how-to-export-power-bi-data-to-excel

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi  @lmireland ,

In Power BI Desktop, you can choose between the following two ways.

1. Cope table - copy directly to Excel afterwards

vyangliumsft_0-1678067732649.png

2. Export table in Visual.

vyangliumsft_0-1678067779503.png

 

In Power BI Servcie, you can choose between the following two ways.

1. Export data from a Power BI visual to Excel with “Export Data”

vyangliumsft_2-1678067732655.png

2. Export large data sets from Power BI to Excel with “Analyze in Excel”

vyangliumsft_1-1678067801030.png

 

Both "Export data" and "Analyze in Excel" have restrictions on their use, you can check the following links::

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d...

Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn

https://www.datacamp.com/blog/how-to-export-power-bi-data-to-excel

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.