Forum Discussion
Incremental Refresh for Fabric Warehouse Views
Super User
What I would say to this is if you have got your range start and range end correctly configured in your power BI semantic model, it should then only be sending the range dates that is needed to query from the warehouse which means it should not query the entire table. I have seen this working successfully and can even do it on CSV files as an example. So it's more around configuring your power BI semantic model correctly. What will then automatically send the required queries down to the data source.
Hey Gilbert,
During the conversations I've had with Microsoft support, they seem to believe there's some sort of row limit at which the incremental refresh won't work and then falls back to a full refresh which sounds slightly suspect to me especially as they cannot detail what that limit is. They've also confirmed in a ton of different ways that the incremental setup I've done is accurate, don't know what you think?
DateTime.From(Date.AddDays(DateTime.Date(DateTime.LocalNow()), -1))
meta
[
IsParameterQuery = true,
ExpressionIdentifier = "RangeStart",
Type = "DateTime",
IsParameterQueryRequired = true
]
DateTime.From(DateTime.Date(DateTime.LocalNow()))
meta
[
IsParameterQuery = true,
ExpressionIdentifier = "RangeEnd",
Type = "DateTime",
IsParameterQueryRequired = true
]
let
Source = Sql.Databases("xxxxxxxxxxxxxxxxxxxxxxxxxx-xxxxxxxxxxxxxxxxxxxxxxxxxxx.datawarehouse.fabric.microsoft.com"),
Test = Source{[Name="Test"]}[Data],
pbi_Transactions = Test{[Schema="pbi",Item="Transactions"]}[Data],
#"Filtered Rows" = Table.SelectRows(pbi_Transactions, each [Transaction Date] >= DateTime.Date(RangeStart) and [Transaction Date] < DateTime.Date(RangeEnd))
in
#"Filtered Rows"