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 am using an append query to union a snowflake data source with a SQL server data source, the process is working but I have a query regarding the refresh process, it seems currently that I bring the two tables in to Power BI so I can append them, but then the append query then goes back to the source and takes the data from the source again, whereas I would have expected that process to take the data it has just pulled in to the power BI environment and then simply union the two together internally. The data sources combined are circa 20 million rows so ideally for speed and size I would rather just have the grab done once and stored once.
Is there any option to achieve this without looking at datamart etc (we are using premium so is an option)?
Any advice much appreciated.
Thanks
Please see this video for an explanation of how Power Query operates.
Inside Power Query reference queries for Power BI and Excel - YouTube
Pat
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.