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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors