Combining Queries from Multiple Sources in Power BI using Merge and Append
March 1st, 2022 in Azure, Blog, Business Intelligence, Power BI, Power Query, SQL Server, UncategorizedIt is always good practice to do as much data preparation as close to the sources as you can before importing or connecting them to your Power BI reports, but what if there are circumstances where this isn’t possible? I had an issue recently where a third-party application had been updated and both the new and legacy versions were being used side-by-side. Logging data from both versions was being written to two separate Azure SQL databases.…
» Read more