Forum Discussion

Leandro's avatar
Leandro
Advocate I
7 years ago
Solved

Python Validate Email Error

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...
Need Help
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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