Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
am I first one to see the "The given key was not present in the dictionary." error?
Some search didn't give any results
thanks for your work
- illeke6125 years agoFrequent Visitor
I'm expieriencing the same issue.
Tried it on multiple PBI datasets
'The given key was not present in the dictionary'
- st_oleg5 years agoFrequent Visitor
Moreover, tried it on multiple PBI accounts
- jeroenterheerdt5 years ago
Microsoft Employee
does the model have a measure-only table by any chance?
- jeroenterheerdt5 years ago
Microsoft Employee
Hi, does the model have a measure-only table by any chance?
- st_oleg5 years agoFrequent Visitor
actually, it does.
i'll try adding a column there
thanks
- pr20005 years agoFrequent Visitor
I'm in the same boat st_oleg. Second!
I have a report with a single dataset on PowerBI.com. When I attempt to convert it to a local model, I see the same error: "The given key was not present in the dictionary"
- pr20005 years agoFrequent Visitor
Not sure if this of any help but this dataset is underpinned by Databricks. I attempted the same activity using a different dataset underpinned by an On Prem SQL db, ,and was successfully able to do so.
- ncmiller5 years agoFrequent Visitor
I've experienced the same issue. See my post above.
- st_oleg5 years agoFrequent Visitor
yeah, now I see it,
exactly, I've got same error window and additional info.