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

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