Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
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
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
50 |
User | Count |
---|---|
212 | |
89 | |
80 | |
69 | |
60 |