Issue with Data Update

[rohanjha1988]

Dear All,

I am new to Power BI and Dax. Currently I am using Power pivot to do some sales and distribution analysis. But I am facing challenge in updating the data in Power Pivot data model. 

I have a Customer master file in which details of all customers are available. Now If I add rows in Customer Master then upon refreshing the data model in power pivot the rows are added automatically. Now, if i add a column in Customer Master then upon refreshing the model is refreshing but the column is not added. 

Please suggest!!

[v-diye-msft]

Hi @rohanjha1988 

Please refer to the similar solved cases whether helps:

https://community.powerbi.com/t5/Desktop/New-column-in-source-table-not-appearing-in-dataset-after/t... 

https://community.powerbi.com/t5/Service/New-column-in-source-table-not-appearing-in-dataset-after/m... 

[rohanjha1988 · Accepted solution]

Many thanks for the reply. 

But I got a solution myself. In the Design Tab, you will find a button called "Table Properties". When you click this, the table will appear and you can see the extra added column in it. You just need to click the same to add in the data model. 

[Greg_Deckler]

@rohanjha1988 - This can often happen with things like CSV files, you have to edit the Source step in Advanced Editor and remove the part that specifies the number of columns.

Source = Csv.Document(File.Contents("C:\temp\powerbi\wagons.csv"),[Delimiter=",", Columns=10, Encoding=1252, QuoteStyle=QuoteStyle.None]),

[rohanjha1988]

@Greg - Can you please help me with the steps of the same.