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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Ashwin_Wadalkar
Frequent Visitor

How to get the source data file in original format

Hi,

 

I had an excel file on my laptop, which i used to upload/ refresh the data on Powerbi desktop & then further to publish.

Unfortunatly, My laptop got crashed & lost all my upload files.

 

Please advice me how can I get my source files in original format.

 

I tried to download the powerbi & table data from the pbix file.

But it always returns with errors viz. "Loading blocked by failures with other queries" . "The key didn't match any rows in the table."

 

Please Please guide me how can I dealt with this issue.

 

Thanks,

Ashley

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @Ashwin_Wadalkar ,

 

Power Query Editor -> Data source settings -> Change data source.

Check whether the path of the data source is the same as it in the Power BI Service datasource setting.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
Super User
Super User

@Ashwin_Wadalkar , Download pbix from power bi service 

then open it , right-click on the table in data or report view , choose copy tbale option and paste it in excel

 

refer

https://www.youtube.com/watch?v=1_XlyzV-PcY

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks for you reply.

 

I did it. But when i tries to upload the same file in powerbi desktop,

it returns with errors as . "Loading blocked by failures with other queries" . "The key didn't match any rows in the table."

 

Please guide me on how can i resolve the errors & upload the same file again.

 

Thanks,

Ashley

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!