Data refresh + Append + Summarized Tables

[ontario234]

Hi,

I have 4 million rows of data in my power BI desktop (32bit june 2017 version). I imported the data from my database for each year sepeartly (from 2009-2017). Then , I created an append table (from edit queries), which is combining data from all these years and named it as "ALL". I have the following questions now:

a) I need my 2009-2016 data to remain fixed and this is why I just refreshed 2017 data. When I do that, i notice that the "ALL" table doesnt get updated. I had to update/refresh "ALL"manually (which is very time consuming since it starts refreshing data from each table one by one)....Shouldnt the table "ALL" be automatically updated once any of 'year' table is refreshed.

b) Using the table "ALL", i created some summarized tables (using modelling-->Newtable). Do these summarized tables need to get updated manually as well? or they get refreshed automatically once the "ALL" is refreshed? Dont these summarized tables behave like queries in MS-ACCESS?

[Anupa_Jayakody]

Hi, i have daily data coming in, so i need to shedule to pick the new file and append and refresh, how is this possible

[v-huizhn-msft · Accepted solution]

Hi @ontario234,

 a) I need my 2009-2016 data to remain fixed and this is why I just refreshed 2017 data. When I do that, i notice that the "ALL" table doesnt get updated. I had to update/refresh "ALL"manually (which is very time consuming since it starts refreshing data from each table one by one)....Shouldnt the table "ALL" be automatically updated once any of 'year' table is refreshed. 

---

The "ALL" table can not update automatically, if load the dara in import mode.  As I tested, you 2017 year data changes in your database, you must click the "Refresh" in Power BI desktop, so that the data updates.

If you load your data in DirectQuery model, the data in database changes, the date in desktop can changes.

In addition, you can create report in Power BI desktop and publish it to service, install a gateway to transfer data, create schedule refresh, the report and dataset will refresh automatically. Please review the articles below.

Data refresh in Power BI
On-premises data gateway
On-premises data gateway in-depth

---

b) Using the table "ALL", i created some summarized tables (using modelling-->Newtable). Do these summarized tables need to get updated manually as well? or they get refreshed automatically once the "ALL" is refreshed? Dont these summarized tables behave like queries in MS-ACCESS?

---

If your ALL table is refreshed, the summarized table also refresh on the same time.

Best Regards,
Angelia