14.5 Append different data sources in Power BI (Power Query) | Power BI Tutorial for Beginners

#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.pavanlal...
📚 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.pavanlal...
You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX
🎉 🔗learn.pavanlal...
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 ✅

[@PavanLalwani]

🚀 Calling all data enthusiasts! 💼🌟 👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off! 🔗 Grab your discounted spot here: learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d 💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼 🔗 Explore the possibilities here: learn.pavanlalwani.com/courses/Power-BI-Dax-634fa813e4b0c08ed56c9919

[@nandesudora8021]

00:09 Appending multiple data sources in Power BI 00:41 Using subscribe and create folder in Power BI for data sources. 01:02 Appending different data sources in Power BI 01:43 Learn how to append different data sources in Power BI using Power Query. 02:07 Introduction to Power Query append function 02:26 Subscribe to the channel for more content. 03:16 लिक्विड ऑप्शन और डाटा इंट्री प्वाइंट के विवरण

[@yadikishameer9587]

Please create videos on Dax functions, data modeling and power bi service. No one is creating good videos in these concepts. 🙏🙏🙏

[@vsr1727]

Thank you 👍

[@யாழ்குறும்பு]

Great

[@fog2640]

finished practicing

[@kishore240284]

you always explain simple functions. when are you going to teach complex things like DAX, etc.

[@PavanLalwani]

Whenever you say Sir Always at your service I was waiting for your comment

[@prv9kumar]

even after I disable load, the source table are also being loaded. Why does this happen and how to solve it

[@devinenipradeep7771]

Please uplode daily 3 to 4 videos

[@PavanLalwani]

Uploaded 3 videos for you today

[@VenkyChalla123]

Pavan its Possible to load a Folder Which Contain both Excel files and CSV files