Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I have some Orders details data into tables I have segragated by year. I am bringing these into BI tables from SQL. As thjis is historical data (2019-2021), that will not change once I load it initially from SQL, I'd like to convert the tables (or copy them I guess) into static Power BI tables and then just incrementally pull from sql daily updates to the latest table as to append the orders data.
Any thoughts on how to first convert these pretty large data tables form SQL fed to static, and then create a union to join the various tables by year into one table in SQL so that I can append the daily updates to it? Thanks in advance
Solved! Go to Solution.
You want to look into incremental refresh which is designed to handle the schenario you describe.
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
You want to look into incremental refresh which is designed to handle the schenario you describe.
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |