How to add a new colunm to a table in the data model

[mikro87]

Hello everybody, 

I have a dashboard in which I want to add a column that was added in the database after I added the table in the dashboard. 

This is how the table is included in Power-Query:

Can someone tell me how to integrate the new field?

Thanks

mikro

[AllisonKennedy]

@mikro87  What are your other steps in Power Query? Do you have a Removed Other Columns step or something similar? Click the settings cog on that step and select the new column. 

If that doesn't work, please click Advanced Editor and paste that entire code into here so we can assist.

[mikro87]

hi @AllisonKennedy, 

in the Advanced Editor I have this script:

The is no typical SQL script. How can I add something here?

[mikro87]

I'm using the incremental load here. Also, I "just" selected the table as I added it to the dashboard without giving a query.

[mikro87]

let
Quelle = Sql.Databases("BISERVER"),
#"CT dwh 03 Intelligence" = Quelle{[Name="CT dwh 03 Intelligence"]}[Data],
sales_vFactOrderInvoice = #"CT dwh 03 Intelligence"{[Schema="sales",Item="vFactOrderInvoice"]}[Data],
#"Gefilterte Zeilen" = Table.SelectRows(sales_vFactOrderInvoice, each [TransactionDateDimCalendarId] >= StartDate),
#"Gefilterte Zeilen1" = Table.SelectRows(#"Gefilterte Zeilen", each [LastUpdate] > RangeStart and [LastUpdate] <= RangeEnd),
#"Gefilterte Zeilen2" = Table.SelectRows(#"Gefilterte Zeilen1", each true)
in
#"Gefilterte Zeilen2"

[mikro87]

for other talbes it looks like this: 

let
Quelle = Sql.Database("BISERVER", "CT dwh 03 Intelligence", [Query="SELECT [DimUserId]#(lf) ,[user]#(lf) ,[CreationDate]#(lf) FROM [CT dwh 03 Intelligence].[sales].[tDimUser] with (nolock)"])
in
Quelle

[AllisonKennedy]

@mikro87  The first one you posted (vFactOrderInvoice) should return the new columns if they are added. 

The second one you posted ( let
Quelle = Sql.Database("BISERVER", "CT dwh 03 Intelligence", [Query="SELECT [DimUserId]#(lf) ,[user]#(lf) ,[CreationDate]#(lf) FROM [CT dwh 03 Intelligence].[sales].[tDimUser] with (nolock)"])
in
Quelle) has a select statement using SQL, so will only return the columns mentioned in the SQL statement. 

Click the settings cog next to the source (Quelle) step, expand 'Advanced Options' and add the name of the new column you want to the 'SELECT ' statement. 

[mikro87]

@AllisonKennedy, so if I get this right, (vFactOrderInvoice) should automatically add new field? So this like select *?

[AllisonKennedy · Accepted solution]

@mikro87  You may need to click the 'refresh preview' button to see the new columns in Power Query.

[AllisonKennedy]

Correct @mikro87 , your fact table query does not appear to have any columns selected, so is identical to select *