cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hpandya2021
New Member

Is it possible to save the tables within Power BI Datasets to an Excel or Sharepoint?

Hey Y'all PBI Gurus,

 

Wondering if it's possible to save the tables within Power BI Datasets to an Excel or Sharepoint List format.

So basically I have a PBI report (with PBI datasets). Want to save/export these PBI datasets into SharePoint. 

 

Wondering if anyone has done this before.

 

Thanks very much,

HPandya

1 ACCEPTED SOLUTION
v-caitlyn-mstf
Community Support
Community Support

Hi @hpandya2021 ,

 

In addition to the manual paste as @kcsteele mentioned, you can also choose to use Dax Studio
or with the help of Power BI Desktop local port number.


Here are the details of how to do it:

 

How to Export Power BI Data to Excel (Step-by-Step) 

 

Extract Table Size from Power BI Desktop Using DAX Studio 

 

Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods 

Recommend:

Exporting Data from Power BI Desktop to Excel and CSV – Part 2: Importing Power BI Data Directly to ... 

 

Hope it helps,


Community Support Team _ Caitlyn Yan


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

3 REPLIES 3
v-caitlyn-mstf
Community Support
Community Support

Hi @hpandya2021 ,

 

In addition to the manual paste as @kcsteele mentioned, you can also choose to use Dax Studio
or with the help of Power BI Desktop local port number.


Here are the details of how to do it:

 

How to Export Power BI Data to Excel (Step-by-Step) 

 

Extract Table Size from Power BI Desktop Using DAX Studio 

 

Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods 

Recommend:

Exporting Data from Power BI Desktop to Excel and CSV – Part 2: Importing Power BI Data Directly to ... 

 

Hope it helps,


Community Support Team _ Caitlyn Yan


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

kcsteele
Helper I
Helper I

you can right click a table or column and select "copy table" or just "copy" to copy a single column and then paste into an excel workbook.

Thanks very much! Is possible to avoid manual steps? Kind of save the PB datasets directly to the Sharepoint?

 

Thank you,

HPandya

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors