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.
So I have this situation, please see code snippet below:
How do I prevent this refresh of the large ODBC data set?
I have already tried toggling the Background Data and Parallel Loading options with no success.
Thanks in advance!
let
Source = raw_data,
#"Added Custom" = Table.AddColumn(Source, "decay", each Number.Power([age],b_value))
in
#"Added Custom"
Hi @ns29 ,
It seems that you want to refresh partial data, right? I think you might could try the incremental refresh, you could service-premium-incremental-refresh for details. But you need to pay attention, incremental refresh also has some limits, you could refer to above link.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dax, I'm not looking to refresh any data in a single session of analysis once the data has been pulled into the file. Incremental refresh would not work in my case unfortunately as it asks for parameters on the data set itself where I have none set.
I know I'm doing something wrong, hard to believe the engine isn't smart enough to know when to not fetch data. Hopefully someone else can chime in here.
Thanks!
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.