Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone!
I have been working with Power BI for just about a month now but am having some difficulties with updating my data. When I originally uploaded my table, it had 9 columns:
.
Since Grey and Orange were never the correct colours to be used, I deleted them from the file. So now, the document appears as:
.
But now when I'm trying to refresh the data, even though the columns Orange and Purple were empty, I'm getting an error that says
"Expression.Error: The column 'Orange' of the table wasn't found."
Is there any way I can still update the data even though the original data had the extra columns? It would be a pain to have to manually add the columns Orange and Grey every time I wanted to refresh my data.
Thanks!
UPDATE: The reason it said Expression.Error is because it was still trying to change the type of Orange and Grey, so I just modified the "Chahnged Type" Step. The new Error is:
"Failed to save modifications to the server. Error returned: 'Column 'Year for Seller' in the table 'Colour Sellers' cannot be found or may not be used in this expression. An unexpected error occured (file 'tmtransactioin.cpp', line #, function 'TMTransaction::GetProxyFromPrevSavePoint').' However, I don't have any measures or calculated columns that are related to this column in the other table at all, and the 'Colour Sellers' table is no longer there.
Solved! Go to Solution.
I'm sorry it turns out I had not deleted the table after all, just hidden it. I deleted the 'Colour Sellers' table and everything works now 🙂
Thanks for your help!!
I'm sorry it turns out I had not deleted the table after all, just hidden it. I deleted the 'Colour Sellers' table and everything works now 🙂
Thanks for your help!!
If you could go into Query Editor, Advanced Editor and paste the text of your query, we can probably point out where you are getting the error.
go into edit queries and remove the step where you deleted the column
I actually had to remove the entire table because it turned out to be irrelevant data, and the column was a calculated column within the table I had deleted.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |