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 all,
Do you know how to permanantly delete collumn from a table and refresh with a new table without the collumns?
When I do it I get an error saying it could not not finde the deleted collumns.
Thanks in advance
@brunoRF For visual tables you should be able to remove the information from the "Values" section in visualizations. If it is a column in your data you can also delete this in the query editor.
If this doesn't address your issue can you post a picture of what you want to delete for more context?
yes but when i delete them in the query and i delete them in sql...when i refresh the table power bi still asks for the deleted collums
hi, @brunoRF
You should have some steps in your query that explicitly reference the deleted column. You can open advanced editor on your query, then find the deleted column in it, and correct the codes in advanced editor. This way, you will be able to refresh data in Power BI Desktop.
Best Regards,
Lin
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |