Forum Discussion

abdulmannan1991's avatar
abdulmannan1991
Icon for Helper II rankHelper II
6 years ago
Solved

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...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to remove this:

    {"vendor", type text},

    See blue line as below:

    Hope this helps.

     

    Best Regards,

    Giotto

KBO's avatar
KBO
Icon for Memorable Member rankMemorable Member
6 years ago

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!

  • abdulmannan1991's avatar
    abdulmannan1991
    Icon for Helper II rankHelper II
    6 years ago

    KBO  

    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. 

     

    • v-gizhi-msft's avatar
      v-gizhi-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi,

       

      Please try to remove this:

      {"vendor", type text},

      See blue line as below:

      Hope this helps.

       

      Best Regards,

      Giotto