Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Our current method of pulling data is using a web connection via DB2. The issue I am having, is that the data in the database is only stored for 6 months. Is there a way in Power Bi to save the old data(Update table) upon refresh? I tried implementing incremental refresh but could not get it to work. My range start and range end could be wrong but I'm really not sure. Thanks for your help!
@nickbowman , see if DAX append can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |