#pavanlalwani #powerquery #excel #dataanalytics
In this Power BI tutorial, we will explore a new topic on how to append different data sources in Power BI. Whether it's SQL, Oracle, Big Data, Hadoop, or any other data source, you can learn the process of appending data sources using a simple example of appending an Excel file with a CSV file in Power BI.
To begin, we will take a look at a folder named "Monthly Sales File" containing two files - April and March. These files consist of the same columns: date, client, and sales. With a total of 10 records, each file represents a different month. Our goal is to append these records and create a consolidated dataset.
To follow along, you can open Power BI and click on "Get Data" to import the Excel file. Select the April 2020 file and click on the "Load" button. Similarly, import the CSV file from March 2020. Once both files are loaded, we can proceed to append them using Power Query.
On the left-hand side of the Power Query window, under "Transform Data," you will find the loaded queries. Click on "Append Queries as New" and select the April file as the top query and the March file as the bottom query. This will create a new appended query with the combined data.
After appending the data, you will see that the columns from both files are properly merged. At this point, you can disable the load for the original tables and enable the load for the appended query. Finally, click on "Close and Apply" to view the output in the Power View.
In conclusion, this tutorial has provided a step-by-step guide on how to append different data sources in Power BI. By following these instructions, you can consolidate and analyze data from diverse sources within Power BI.
---------------------------------------------------------
💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount:
🔗 learn.pavanlalwani.com/course...
📚 200+ MCQs to test your knowledge.
📝 20+ Assignments for hands-on practice.
🔍 11+ Case Studies for real-world insights.
💼 5+ Industry Projects to build your portfolio.
🎓 Course Completion Certificate for your resume.
💡 Tips & Tricks to boost your skills.
🔎 5+ Industry Datasets for practical learning.
Join thousands of professionals who have transformed their careers. Enroll now at 50% off!
🎉🔗 learn.pavanlalwani.com/s/store
You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX
🎉 🔗learn.pavanlalwani.com/course...
Invest in yourself. Become a Power BI expert. The future is yours! 💼💪"
📥 Download Practice Material from Server 💾:
#datacleaning #businessintelligence #powerbi
---------------------------------------------------------
Timestamps:
00:00:03 Introduction to Appending Data Sources in Power BI 📊
:00:26 Exploring Files: April and March 📂
00:00:53 Understanding Column Similarities and Monthly Differentiation 📅
00:01:20 Loading Excel File: April 2020 📁
00:01:49 Loading CSV File: March 2020 📄
00:02:18 Accessing Power Query and Appending Queries 🔄
00:02:46 Creating New Query: Appended Data 💡
00:03:15 Disabling Unnecessary Queries and Finalizing Output ✅