Refresh data on a merged query not updating new data

[nmckeown1]

I have created a merged query in power query which worked perfectly (added a column in excel sheet to a sql model).

Then when I added new source data to the excel, and refreshed, the data itself updates fine in the new table (table_excel), however it is not pulled into the other table (table_sql) where the query was added. I've tried refreshing in table view and transform data view, and the query just wont add the new data. 

Any help?

[danextian]

Things to check:

• is the new table being referenced in the merged query?
• Are the new columns expanded in the merged query?
• Subsequen steps that might have removed these columns?

[Kedar_Pande]

@nmckeown1 

1. Go to the Manage Queries pane in Power BI and ensure that both table_sql and table_excel are correctly linked in the data model.
2. Refresh the entire data model, not just the table. Right-click on the data model in Power BI and select "Refresh All".
3. Try clearing the data model cache via File > Options > Data Load > Clear cache.

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn