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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors