Desktop Refresh Error: Query "references other queries or steps ... "
I will try to have a look at the query causing the error.
But I am not sure that this link will help preventing me having this error while refreshing from desktop as I proceed exactly like you.
I split all my queries into small ones.
The first always beeing the "import" query from the source. (not loaded in the data model)
Then I do all the other queries starting from the import query.
Like on this model:
The error by refreshing always comes from "Check Notif" and this is my editor:
let
Source = Table.NestedJoin(#"01 Import Mail", {"ECO"}, TRACKING_ECO_STATUS, {"ECO"}, "TRACKING_ECO_STATUS", JoinKind.LeftOuter),
#"TRACKING_ECO_STATUS développé" = Table.ExpandTableColumn(Source, "TRACKING_ECO_STATUS", {"ECO", "Notification_Date"}, {"ECO.1", "Notification_Date"}),
#"Colonne conditionnelle ajoutée" = Table.AddColumn(#"TRACKING_ECO_STATUS développé", "Check Notif", each if [Date Received] = [Notification_Date] then true else false)
in
#"Colonne conditionnelle ajoutée"
So I don't see any "external data source" on my query, while it is always bringing me the error we are talking about in this post.