how to use python with multiple tables Power BI

Published on Mar 18,2024:
In this video, we will learn to use python script to merge multiple tables in Power Query editor. We use pandas to manupulate the data.

In this comprehensive tutorial, I'll guide you through the ins and outs of using Python in conjunction with multiple tables in the Power Query Editor.
Whether you're a data enthusiast, a professional looking to streamline your workflow, or a curious learner, this video is your gateway to mastering
this powerful combination.

💡 What You'll Learn:

How to seamlessly integrate Python scripts within the Power Query environment.
Techniques for manipulating and analyzing data across multiple tables.
Practical tips for enhancing your data processing capabilities.

🌟 Features:

Step-by-step instructions that are easy to follow.
Real-world examples to illustrate key concepts.
Insightful commentary on the advantages of using Python in Power Query.

🚀 Elevate your data processing skills and unlock new possibilities in data analysis. Join me in this educational journey and transform the way you handle complex datasets. Don't forget to like, share, and subscribe for more content like this!

Below is the script used for the demo:
# Python:
import pandas as pd
df3['Value3'] = df1['Value1']*df2['Value2']

SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!

Our Playists:

ABOUT DAGDOO:
Website:

Questions? Comments and SUGESTIONS? You will find me here:

Twitter: @dagdooe

Category: Science & Technology
License: Standard YouTube License

[vbargesoc]

solved my major problems. thank you for the video & solution

[jobseeker]

Thanks a lot....can you tell me why following your process is converting all of my column types to text in the new can i prevent that? Especially the date columns dont return the date but Microsoft.OleDb.Date value. Forcibly changing it to date returns error.

[faezesafari]

Thank you for the video. Super helpful! I have one issue and was hoping you could help me with it. I'm getting the error "Expression.Error: Parameter 'df1' isn't a table" when I follow the steps in your video, while df1, which is Table1, is a table as shown below:
= Source{[Item="Table1", Kind="Table"]}[Data]

Do you have any ideas on how I can resolve the issue?