Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to Solution.
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.
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.