Power BI - Validate Email Addresses with Python (Outdated, see description)

Hey guys, Parker here! In this video, I'm going to show you how you can validate email addresses with the validate_email Python module. This is super simple and only requires a couple lines of code. You will be able to validate if the email is syntactically correct and if the email address is actually a real address used by someone! Hope you enjoy this trick!

Enroll in my introductory or advanced Power BI courses:

Elite Power BI Consulting:

Data Insights Tools:

Connect with me on Twitter!

[joaopaulodepaivaholz]

You are the best bi channel of youtube, everyone else just say the obvious

[vishalpawashe]

A good way to check the long list of valid emails using Python and using the lambda function to iterate through each row. Thanks for this great idea

[treublaan]

I keep getting: Formula.Firewall: Query 'checkEmail' (step 'Run Python script') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
What to do?

[avaniheriss]

It works for a small number of rows like in thousands but more than that not working

[kdulable]

Hi there! Very helpful video, however I'm getting some problems with the script ->
DataSource.Error: ADO.NET: A problem occurred while processing your Python script.
Here are the technical details: [Expression.Error] We couldn't convert to Logical.
Details:
DataSourceKind=Python
DataSourcePath=Python
Message=A problem occurred while processing your Python script.
Here are the technical details: [Expression.Error] We couldn't convert to Logical.
ErrorCode=-2147467259



Do you know by chance what could be an issue? Thank you very much.