Hello,
I am running into a scenario where a PBI table (Table B) that is sourced as a reference to another PBI table (Table A) is only retrieving data between the Parameters of RangeStart & RangeEnd. Table A contains the parameters within its M Code as a requirement to incremental reference. The incremental reference is setup to go beyond the date range of the parameters. My intention is that when Table B is refreshed, it grabs the data post the partitions processed from Table A without the parameters being applied as filters.
For example,
Table A -> displays data between 2023-01-01 to date
Table B -> displays data between 2023-06-01 & 2023-06-31
RangeStart & RangeEnd
RangeStart = #datetime(2023, 6, 1, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]
RangeEnd = #datetime(2023, 7, 1, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]
Table A -> Incremental refreshed set up for Monthly partitions ~ 12+ partitions
let
Source = Sql.Database("SERVER", "DB"),
BigTable = Source{[Schema="SCHEMA",Item="TABLE"]}[Data],
IncrementalFilter = Table.SelectRows(BigTable, each [Date] >= RangeStart and [Date] < RangeEnd)
in
IncrementalFilter
Table B
let
Source = #"Table A",
DoOtherStuff = RemoveColumns_FilterColumns_DoADistinct
in
DoOtherStuff
Whats else do I need to setup for Table B to take the entirety of Table A (i.e. ignore the parameters)? I dont believe this is a precendence issue (yet) as calling for Table B to be refereshed in SSMS does not resolve the issue. Also when I have use tabular editor to adjust the parameters to a larger range and reprocess Table B, the data reflects the new range.
Open to suggestions. The reason for the reference is remove query redundancy to the source system.
Thanks!
