Forum Discussion

johanvdk67's avatar
johanvdk67
Regular Visitor
4 years ago
Solved

executing an external python script from Powerbi

I have an external python script, this runs without errors when I execute from Python:     import pandas as pd data = [['Alex',10],['Bob',12],['Clarke',13]] df = pd.DataFrame(data,columns=['Name'...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    johanvdk67  - Okay, so the issue is not the Python step, it is the opening of the Binary file.  It must have a funny character or binary format that is confusing Power Query.

    Could you open the Example.Py file in Notepad - like this - Mine is working.

     

      

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi johanvdk67 .  Have you checked the firewall settings,

 

and what does the result of the "Text.FromBinary" step look like?

let
Source = File.Contents("C:\Temp\python.py"),
Custom1 = Text.FromBinary(Source)
in
Custom1