Forum Discussion

mim's avatar
mim
Advocate V
9 years ago
Solved

append the same table without double refresh

hi    is it possibe to append the same query without having to refresh both ?
Need Help
mim's avatar
mim
Advocate V
9 years ago

let's put it in a different way in this query

 

let
Source = Excel.Workbook(File.Contents("C:\Users\mimoune.djouallah\Desktop\tar\TAR.xlsx"), null, true),
COMBINED_Sheet = Source{[Item="COMBINED",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(COMBINED_Sheet),
#"Appended Query" = Table.Combine({#"Promoted Headers", #"Promoted Headers"})
in
#"Appended Query"

 

when i hit refresh does powerquery call this step "Source" one time or two time ?

 

note: i am familiar with powerquery, i have a query that fetch 2Millions records and do all kind of transformation, but it become quite slow, nearly 15 minutes to finish, so i am trying to fine tune a better solution

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

It is fetching the data from scratch everytime you hit refresh. If you would like to fetch just newly added rows, You can use partioning in SSAS Tabular which will only fetch the newly added data.  This is the negative of PQ. However, If you use PowerPivot, It is faster to load data using powerpivot get data option.