You’re offline. This is a read only version of the page.
2
Hi Team,
I am currently trying to perform data loads into the MSM via a Power Query template, but I always get following error:
Share
ReportCouldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: The column 'Column2' of the table wasn't found. Details: Reason = Expression.Error;ErrorCode = 10224;Detail = Column2;Microsoft.Data.Mashup.Error.Context = User
Within the Power Query I'm creating a few help tables to perform my data transformations. Those tables will not be imported into the MSM and should also not be loaded. But every time I open the connection or the template, the tables that should not be loaded are loaded anyway. The "Enable load" function cannot be turned off it seems.
I strongly suspect that the error occurs because the temporary table is tried to be loaded into the MSM...
Any idea on how to fix that?
Cheers,
Lea
The error occurs because Power Query is trying to load temporary helper tables into Microsoft Sustainability Manager (MSM).
To fix this, open Power Query Editor and identify the helper tables. Use a workaround like appending a step to make these tables unreachable (e.g., Table.RemoveColumns(Source, {"NonExistingColumn"})). Ensure the "Enable Load" option is effectively bypassed, and confirm that all required columns in the main query are present and correctly named. Finally, test the connection after adjustments to ensure only the intended data is loaded into MSM.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,993
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (