cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
annerogers
Helper I
Helper I

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 to delete doesn't exist.  It looks like it shows this as being from the "remove column 3" of the list of applied steps I did a couple weeks ago.  Is there a way to correct this so I can get the data to refresh?  This one failing made the other 3 tables I have fail to refresh as well.  See the screenshots I took below.  Thank you.

errors.png

error.pngerror2.png

1 ACCEPTED SOLUTION

SSMS - SQL Server Management Studio

View solution in original post

5 REPLIES 5
v-qiuyu-msft
Community Support
Community Support

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

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

SSMS - SQL Server Management Studio

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

Hi @annerogers,

 

Glad to hear the issue is solved. Smiley Happy

 

As the issue is related to connection changed after you check in SSMS, would you please also mark my previous post as an answer if you think it's helpful?

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!