Forum Discussion

KRANJAN's avatar
KRANJAN
Frequent Visitor
7 years ago

Power BI Close and Apply from Query Editor

I have the Table structure which is roughly like

Table1 (from postgres database)

Table2 (references Table1)

Table3 (references Table2)

 

TableA (from postgres database and merges with Table3)

 

So If I now make some change to Table1 in query editor and save and apply then will all the depended queries also get refreshed (Table2, 3, A)? Becasue when I try that then a popup comes showing loading Table1 and Table2 only and after loading when I check the TableA data it remains unchanged.

But when I click on the TableA and select refresh data manually it works fine.

Why is it so? So Do I have to manually go refresh all the dependent tables? I would like to avoid refresh ALL tables as that would take too much time

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi KRANJAN 

    I make a test as you did, After i change data in Table1, then immediately Table 2, Table 3,Table A change accordingly.

    Do you make some transformations for Table2? so Table2 is not the same as Table1?

    Is Table 3 the same as Table2?

    When you change Table1, which table do you want to refresh only?

     

    Based on my experience, you could uncheck "enable load" and "include in report refresh" for any tables which is no need to refresh or be displayed in Report/Data view.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.