Forum Discussion
Helper IIncremental Refresh by Year and not by date
You created a Power Query Step called "where" and it will produce a logical true/false but otherwise be completely disjointed from your table.
let Source = Sql.Databases("server\instance"), DataWareHouse = Source{[Name="Database"]}[Data], dbo_OverView = DataWareHouse{[Schema="dbo",Item="_OverView"]}[Data], Filtered = Table.SelectRows(dbo_OverView, each RangeStart <= #datetime([WorkDate_Year],1,1,0,0,0) and #datetime([WorkDate_Year],1,1,0,0,0) < RangeEnd), #"Renamed Columns" = Table.RenameColumns(Filtered,{{"LOB", "Services"}, {"ClientName", "Client Name"}}) in #"Renamed Columns"
Helper Ilbendlin thanks . I created the Paramete "RangeStart" and "RangeEnd". Please tell me where to write the M function. My advanced editor shows the code as
let
Source = Sql.Databases("DEV"),
QADataWareHouse = Source{[Name="QADataWareHouse"]}[Data],
dbo_Report_OverView = QADataWareHouse{[Schema="dbo",Item="Report_OverView"]}[Data],
#"Renamed Columns" = Table.RenameColumns(dbo_Report_OverView,{{"LOB", "Services"}, {"ClientName", "Client Name"}})
in
#"Renamed Columns"
Super UserThe filter needs to be part of the query for the data you want to load into Power BI incrementally. Add the filter as soon as possible in the code.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
- lbendlin
You created a Power Query Step called "where" and it will produce a logical true/false but otherwise be completely disjointed from your table.
let Source = Sql.Databases("server\instance"), DataWareHouse = Source{[Name="Database"]}[Data], dbo_OverView = DataWareHouse{[Schema="dbo",Item="_OverView"]}[Data], Filtered = Table.SelectRows(dbo_OverView, each RangeStart <= #datetime([WorkDate_Year],1,1,0,0,0) and #datetime([WorkDate_Year],1,1,0,0,0) < RangeEnd), #"Renamed Columns" = Table.RenameColumns(Filtered,{{"LOB", "Services"}, {"ClientName", "Client Name"}}) in #"Renamed Columns" - bkan
thanks can you please delete the solution as by mistake i have some sensitive info
- lbendlin
I cleaned it up.