Forum Discussion

jonoCX's avatar
jonoCX
Frequent Visitor
4 years ago

How to investigate Python script error

Hi   I am trying to write a simple script in Power Query Editor in PowerBI, and keep getting an error below:   DataSource.Error: ADO.NET: Python script error. <pi>pandas.errors.MergeError: Data ...
Need Help
YukiK's avatar
YukiK
Icon for Impactful Individual rankImpactful Individual
4 years ago

You may want to look into this documentation taking about how to use an external python IDE with power bi. You might be able to debug there, which I'm not entirely sure is possible. Use an external Python IDE with Power BI - Power BI | Microsoft Docs 

 

But it looks like it's more of an error that resides in your code regarding pandas merge operation. Since it's complaining about "Data columns not unique", I'm guessing there are more than 1 column in the table where the column name is "Date". So maybe consolidating that would help.

 

Hope that helps!