Forum Discussion

annerogers's avatar
annerogers
Helper I
9 years ago
Solved

Error when Refreshing SQL Data

I am getting the error below when I try to refresh my data tables.  I have desktop and am connected to SQL.  In the top screen shot I think it is saying that a column I had selected in my data table ...
Need Help
  • bprerad's avatar
    bprerad
    9 years ago

    SSMS - SQL Server Management Studio

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi annerogers,

 

Regarding the "The column 'supervising_country_code' of the table wasn't found", please check all the steps above Remove Column3 step in Applied Steps to see if there is a column actually called 'supervising_country_code'.

 

Regarding the error "Cannot continue the execution because the session is in the kill state", please go to SSMS, connect to the same SQL Server instance, check if you can query data from the same table you get data from in Power BI desktop.

 

 

Best Regartds,
QiuyunYu

 

  • annerogers's avatar
    annerogers
    Helper I
    9 years ago

    Where is SSMS?  Sorry I am not sure what that is.

    • bprerad's avatar
      bprerad
      Frequent Visitor
      9 years ago

      SSMS - SQL Server Management Studio

      • annerogers's avatar
        annerogers
        Helper I
        9 years ago

        Thank you.  This was the issue, something has changed in the connection.