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.
I have one table that downloads information from a Oracle DB. Because it has millions of lines, it take hours to download. The data does not change in between dates, so I created another query to download the last month numbers and I am trying to append the data. However, when I try to append both tables, it starts downloading the data again from the DB. Any solution here?
Note: I already uncheck ENABLE LOAD and uncheck INCLUDE IN REFRESH REPORT.
Solved! Go to Solution.
Unfortunately that is not possible. What you're trying to achieve is incremental updates and is enabled by default in PowerBI Report Server, not in PowerBI Pro. I know it looks like you can achieve this using this "trick" but it does not really work, i've already tried.
PowerBI in "non incremental mode" works only by full refreshes.
Maybe you can trick it by loading the non-changing data in a table created inside powerbi, but not sure if it works.
Unfortunately that is not possible. What you're trying to achieve is incremental updates and is enabled by default in PowerBI Report Server, not in PowerBI Pro. I know it looks like you can achieve this using this "trick" but it does not really work, i've already tried.
PowerBI in "non incremental mode" works only by full refreshes.
Maybe you can trick it by loading the non-changing data in a table created inside powerbi, but not sure if it works.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |