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.
Does anyone know if it's possible to delete columns of data from the excel source file (that I have uploaded into Power BI) after the fact? I have several columns that are not needed, but when I delete them from excel and refresh Power BI and error occurrs saying "the data is missing". If I delete the same columns from the Power BI file (through edit queries) I still receive the same error.
Thoughts?
Solved! Go to Solution.
Hi, this a common error.
Go to Edit Query and find the Changed Type Step . Review it and delete the columns that you desire. (the same that you erase in the source)
Regards
Victor
Hi @car16,
If you directly delete the column in source file, the update won't be applied to Power Query automatically when you refresh dataset, Power Query will prompt "Connot find column" error. To resolve this error, please delete the corresponding column in Power Query, either. In below example, I delete column [Financial_Year].
Best regards,
Yuliana Gu
Hi, this a common error.
Go to Edit Query and find the Changed Type Step . Review it and delete the columns that you desire. (the same that you erase in the source)
Regards
Victor
Thank You! Easy fix, just something I was not aware of in Power BI (we are just starting to use this more heavily at my company, so learning as I go). Appreciate it.
I wish it worked for me.
It never does.
I end up having to redo all my tables.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |