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?
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
