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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
v-yangliu-msft
Community Support
Community Support

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
v-yangliu-msft
Community Support
Community Support

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors