I created several custom columns in the Lead document in ERPNext, but they have since been deleted. However, when I connect to Power BI, I still see those columns with no values. How can I remove them? Additionally, I’m using Frappe Cloud and don’t know if I have access to make any changes directly in the database.
Deleting a DocField (whether a standard one, or a Custom one) does not automatically drop the corresponding SQL column in the table.
You must take additional steps afterwards to actually DROP the column.
I don’t know anything about Frappe Cloud. But if it allows you to run Server Scripts, then you could write one to clean up the leftover columns and tables.