Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone!
I found this very usefull tutorial on youtube talking about how validate emails with PBI by using a Python script, this i'm getting this error:
Do you guys knows how to solve this?
the script is very simple:
from validate_email import validate_email
dataset['Valid Email'] = dataset['Email'].apply(lambda x:validate_email(x))
Thanks!
Solved! Go to Solution.
Hi Leandro,
Couldn't reproduce your issue. The python script works well on my side. It seems like there's something with your data type, are they text type in your dataset?
Regards,
Jimmy Tao
Hi everyone,
I followed the same tutorial but I get another error when running the script:
I used the same code as the tutorial but there he only has 1 column in his dataset and mine consists of multiple columns with multiple date types.
I tested the code and when I removed all other columns, it worked as expected.
Can someone help me out?
Thanks!
DataSource.Error: ADO.NET: Python script error.
<pi>sys:1: DtypeWarning: Columns (5,7,8,26,27) have mixed types.Specify dtype option on import or set low_memory=False.
TypeError: expected string or bytes-like object
</pi>
Details:
DataSourceKind=Python
DataSourcePath=Python
Message=Python script error.
<pi>sys:1: DtypeWarning: Columns (5,7,8,26,27) have mixed types.Specify dtype option on import or set low_memory=False.
TypeError: expected string or bytes-like object
</pi>
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException
HELP...
I trying but PWBI get this error.. any help please
Hi Leandro,
Couldn't reproduce your issue. The python script works well on my side. It seems like there's something with your data type, are they text type in your dataset?
Regards,
Jimmy Tao
Thanks a lot for the atention.
After some time, i realized that the problem was really the type as you said.
Thanks! Best Regards!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |