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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
KyawMyoTun
Helper III
Helper III

Can export raw excel as original excel from power bi service?

Dear Experts,
   I have uploaded daily excel files to share point folders(Monthly Folder under Year).
The share point folder has completely deleted wrongly and can't restore those data.
Even I can export some data from power bi service, which is not exactly the same as original columns because drop off/add some columns.
My goal is to export the original excel files and re-upload to another share point folder again.
Is it possible? Thanks for your help.

Regards,
Kyaw Myo Tun

3 REPLIES 3
v-binbinyu-msft
Community Support
Community Support

Hi @KyawMyoTun ,

There is a workaround for you,but please keep in mind, this is only suitable for the .pbix file that created with import connection .

Please try below steps:

1. Download the .pbix file from the Power BI Service

2. Open the .pbix file in the Power BI Desktop

3. Open the Power Query Pane, then cancel the steps that you apply in Power Query, then close and apply

4. click "Data" tab, right click table name, then click "Copy table",then paste it to excel

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Dear @v-binbinyu-msft ,

  Thanks for your reply.
As soon as open the power query, it refresh to the original sharepoint.
As there is no data at original sharepoint, it shows the error.
Do you got any other idea?

Best Regards,
KMT

Hi @KyawMyoTun ,

So far, to my knowledge, there is no way.

 

Best regards,
Community Support Team_Binbin Yu

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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