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.
Hi,
I've been using dataset.xls to build visuals. dataset.xls is hitting Excel's technical limit so I'm now directing new data to a new file dataset2024.xls. I'm appending dataset2024.xls to dataset.xls. Given that dataset.xls is now going to be static, i.e. no more new data will be added to it, can I disable load to speed things up?
Since I'm appending dataset2024.xls to dataset.xls, would disabling refresh of dataset.xls also disable the refresh of dataset2024.xls?
before appending, exclude the report refresh on the dataset that is static before appending it to your 2024 data. Make sure that you'll be appending it to your 2024 data and not the other way around.
It seems like I should exclude in report refresh instead?
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.