Every day, I need to add (import) 600,000 new rows to this fact table inside Power BI desktop from SQL server data warehouse.
My concern is how can I incrementally import these new data and add it to the already existing one in my Power BI Desktop model.
Simply refresh data will read every day all the 10 million rows which will be time consuming.
I tried to modify the M code of the fact table to get new rows after a specific date but this solution completely erase the already 10 million rows of the fact table in Power BI Desktop.
Below my M code
let
Source = Sql.Database("10.Xx.Xx.Xx", "MY_DB"),
dbo_fact_table = Source{[Schema="dbo",Item="fact_table"]}[Data],
filteredRows = Table.SelectRows(dbo_fact_table, each [date] >= StartDate)
in
filteredRows
0 comments:
Post a Comment
Thanks