Forum Discussion

1123's avatar
1123
Frequent Visitor
6 years ago

Incremental refresh doesn't work

Hi, I hope you're all doing good and could help me to handle this issue...   I have Power BI Premium account (not sure if that's relevant though) and in Power BI desktop, I created a query defined ...
Need Help
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi 1123 ,

 

Your source consists of 4 further queries, how are these structured?

 

 

1123's avatar
1123
Frequent Visitor
6 years ago

Hi mwegener 

They all have similar structure:

let
Source = Oracle.Database("***DATABASECREDENTIALS***", [HierarchicalNavigation=true]),
TABLEX = Source{[Schema="TABLEX"]}[Data],
TABLE1 = TABLEX{[Name="TABLE2"]}[Data],
#"Added Custom" = Table.AddColumn(TABLE1, "Col9", each "TABLEX")
in
#"Added Custom"

 

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi 1123,

     

    I would also add the filtering to the subqueries to ensure that the query folding works and that the data is filtered directly at the source.

    However, I see no reason why the values should not come from the source.

     

     

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Can you share a screenshot of the refresh history?