Python Script ErrorCode=-2147467259 While I Want To Transform a Data From Restricted Google Sheet

[Anonymous]

DataSource.Error: ADO.NET: A problem occurred while processing your Python script. Here are the technical details: [DataFormat.Error] N_A Details: DataSourceKind=Python DataSourcePath=Python Message=A problem occurred while processing your Python script. Here are the technical details: [DataFormat.Error] N_A ErrorCode=-2147467259 ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonUnexpectedException

This happens while i want to cleaning the data from Power Query using Python Script that the data source was from G-Sheet. I already check the script using other G-Sheet files and it runs, but whenever i try using restricted (only viewer not editor)

 G-Sheet it gets that error. But when i transform/clean the data without python script (only using power query)

it runs perfectly. I really need to used Python Script for my project report is there any other way to done it with python script?

[lbendlin]

Remove the N/A  fields from your Google Sheets source.