Forum Discussion

swang123's avatar
swang123
Frequent Visitor
6 years ago

ODBC Dataflow Refresh Error

Hi everyone! Having an issue with a dataflow refresh, hoping someone can assist. We have installed a data gateway on an Azure virstal machine. Data is from an ODBC connection which was refreshing ...
Dataflow
Need Help
JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
6 years ago

Hey swang123 ,

 

please check if

 

  • Your credentials are still right
  • The columns you are using are still in place (columns didn't get deleted or renamed)

I bet someone renamed/deleted a column in your table.

Here are similar threads

 

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...

 

http://community.powerbi.com/t5/Integrations-with-Files-and/Expression-Error-The-key-did-not-match-a...

 

https://community.powerbi.com/t5/Service/Key-Expression-Error-The-key-didn-t-match-any-rows-in-the-t...

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

  • swang123's avatar
    swang123
    Frequent Visitor
    6 years ago

    Hi! Thanks for responding. 

     

    Just checked this out - none of the columns have changed. The Key error only in shows in the PowerBI service website (where we refresh the dataflow). When trying to refresh within the query editor online, it only says that "the query contains errors".

     

    Not sure why this may be happening still?