Solved: Recover data utilizing Power Query

Anonymous · ‎04-07-2022

Recently we've lost some csv files that were used as datasource within power query data transformation steps.

These files had sizes between 1~5Mb, is there a way to load these tables from the PBI file with power query without receiving DataSource.Error messages even if the datasource file does not exist anymore?

Thanks in advance!

AlexisOlson · ‎04-07-2022

Are the tables loaded to your data model in a saved PBIX? That is, do they show up in the Data pane when you open the PBIX in Power BI Desktop?

If so, then you can recover the data by doing something like copy and pasting the table into an Excel file. If the data isn't part of the PBIX (e.g. a query that doesn't get loaded to the model), then you're out of luck.

View solution in original post

AlexisOlson · ‎04-07-2022

Are the tables loaded to your data model in a saved PBIX? That is, do they show up in the Data pane when you open the PBIX in Power BI Desktop?

If so, then you can recover the data by doing something like copy and pasting the table into an Excel file. If the data isn't part of the PBIX (e.g. a query that doesn't get loaded to the model), then you're out of luck.