Power BI: Mastering PowerBI | Combine Multiple Queries into One with Append Query function

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.

Points to be discussed:
• How to combine multiple queries?
• How does append queries function works?
• How do you change the name of append queries result?

#Office365 #BusinessPremium, #Office365 #Business, #Office365 #ProPlus, #Office365 #E3, #Microsoft365 #Business, #Microsoft365 E3, #Microsoft365 E5, #Azure, #Foetron, #MicrosoftPartner #PowerBITutorial #PowerBIPro #MasteringPowerBI

[ron]

Great video. Question. I the two tables I appended as new are from different data file sources (xlsm). The appended query has all the columns for both files. However instead of blending into one table there are duplicate rows. So the table just looks like one table with the other pasted below it. How do I get the columns to combine so it's a clean table that updates when either data source file is updated?