Forum Discussion
New calculated table in Power Query doesn't refresh if Source table is updated
Your FACT table is incomplete - it is part of an incremental refresh. It is, by definition, incomplete. Only the latest data is there after taht first refresh.
You are not reducing a DB call either. Power Query works bottom up, not top down, so say you have this:
- Query 1 to SQL Server
- Query 2 to transform Query 1 to a good FACT table
- Query 3 based on Query 2 to filter your FACT table.
Both query 3 and query 2 will go all the way back to Query 1 independently. Power query doesn't process Query 2 and then use hold the results of that for Query 3. It will redo Query 2, and consequently Query 1.
I am creating a Dim table by summarizing a few columns from Fact table. Using this Dim table in RLS as a link table. Though I can create the same table using a direct sql statement. But to reduce a db call, I am extracting it from Fact table. So, you are suggesting that a direct sql will be a better option ?
Your FACT table is incomplete - it is part of an incremental refresh. It is, by definition, incomplete. Only the latest data is there after taht first refresh.
You are not reducing a DB call either. Power Query works bottom up, not top down, so say you have this:
- Query 1 to SQL Server
- Query 2 to transform Query 1 to a good FACT table
- Query 3 based on Query 2 to filter your FACT table.
Both query 3 and query 2 will go all the way back to Query 1 independently. Power query doesn't process Query 2 and then use hold the results of that for Query 3. It will redo Query 2, and consequently Query 1.