Forum Discussion
Delete Column from Backend Data
Hello. When I try to refresh the Pbix file after deleting a column (say, 'Vendor') from the backend Excel file, it doen't refresh properly and throughs an error that the column 'Vendor' was not found.
Is there a solution to delete a column from backend Excel and get it reflected into Pbix without any error?
(I want to delete a couple of surplus columns from backend Excel file to make my file simple ).
Hi,
Please try to remove this:
{"vendor", type text},See blue line as below:
Hope this helps.
Best Regards,
Giotto
5 Replies
Hi abdulmannan1991 ,
thats was no good idea to delete tables after you build a solution. If you don't use dynamic headers it is a little bit diffecult.
1) You can go to the Power Query Editor - Advanced Editor and adapt the code
If you share it may be I can help :).
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!Please access a small test data using following link: https://we.tl/t-SFdnV5KKFg
It has got a pbix file and a reference Excel dataset. How do we delete the column 'Vendor' in Excel file and then refresh the Pbix without any error?
I also opened the Advanced Editor but unsure what code needs to be modofied.
Hi,
Please try to remove this:
{"vendor", type text},See blue line as below:
Hope this helps.
Best Regards,
Giotto
Hi,
Please try to delete this column query in Query Editor as well.
Hope this helps.
Best Regards,
Giotto
