Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
Solved! Go to 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.
Please refer to the similar solved cases whether helps:
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.
@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]),
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |