replacing data without getting additional tables

Hi eliseglines,
Thank you for posting your query in the Microsoft Fabric Community Forum. Also, thanks to cengizhanarslan & grazitti_sapna for the earlier guidance.

Regarding the error in your screenshot: “OLE DB or ODBC Error: Type mismatch (DISP_E_TYPEMISMATCH)” This usually indicates that some values in the new Excel file do not match the data types expected by the existing Power Query steps. Even if the columns were not renamed, this can happen if the new data contains:

• Text values in columns that previously contained numbers or dates
• Blank or mixed values in numeric/date columns
• Formatting differences introduced when rows were removed

Since the issue appears while loading tables like Outcomes, Treatment, and Cost Savings, it would be helpful to review whether any values in those columns differ in type from the original dataset.

Check the new Excel file for mixed data types or unexpected values in those columns, as that can trigger the type mismatch error during refresh.

Best regards,
Ganesh Singamshetty.