Forum Discussion
Expression.Error: We don't support query strings containing keys without values in this context.
I was wondering if anyone knew what this error meant.
A bit of background, I'm building this dashboard for a client and the datasources are stored on Sharepoint. This morning Power BI failed to refresh. After some investigation it was found that someone on the client side removed one of the datasources (yikes I know!) However after the datasource was recovered I am getting this error and it is popping up on the most random steps. It popped up on a Sorted Rows step. After removing that it now gives me that same error on a merged query step, however there are 2 merged queries steps and the first one doesn't present a problem. I checked the query it was merged with and everything checks out.
I also tried removing everything back through the Sorted Rows step and try simply sorting the row manually and I also got that error. For reference, the steps this error is occuring on are:
#"Sorted Rows1" = Table.Sort(#"Filtered Rows4",{{"Date", Order.Ascending}})
and (when the above step is removed)
#"Merged Queries1" = Table.NestedJoin(#"Added Index", {"Column 1", Column 2}, #"Query", {"Column 1", "Column 2"}, "Query Name", JoinKind.LeftOuter)
3 Replies
- AlexisOlson
Super User
Does the Refresh Preview button help?
The query editor often caches results and those might still have empty values from when the source disappeared.
- ABR002
Helper I
It doesn't. Same thing happens when I try to do a refresh on the front end, the data won't refresh because of that same error.
- AlexisOlson
Super User
Hmm, that's too bad. I guess I'd try creating a new query and manually rebuilding the broken query from the beginning step by step to see if that makes it more obvious where things are going wrong.