🔥 3-day streak
Microsoft Power BI Data Analyst30 / 205
Question 30 of 205

You are building a Power BI report in Power Query. Your sales team exports one CSV file per month, each with identical columns (Date, ProductID, Quantity, Amount). You have 24 separate query connections, one per file, and need a single Sales fact table containing all rows from every month. Which transformation should you use to combine these queries most efficiently?

Reviewed for accuracy · Report an issueNext question