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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.