increase no of columns more than 16 in a table from csv/excel

[Anonymous]

Hi All,

I have dataset from csv and excel.when i build data set one of my  csv file has 16 columns, i have added 2 more columns in source ,when i am importing or refreshing data in desktop new columns are not updating.

where to chnage  accomidate new columns which are 17th and 18th columns - 

thanks

[v-lili6-msft · Accepted solution]

HI, @Anonymous 

Here is a same case I had solved for you refer to:

https://community.powerbi.com/t5/Desktop/Date-cell-not-being-imported-from-CSV/m-p/582186#M275577

https://prathy.com/2016/08/how-to-add-extra-columns-to-an-existing-power-bi-file-which-using-csv-data-source/

https://buildbod.com/2018/05/01/power-bi-csv-refresh-failure/

Best Regards,

Lin