Python Script vs Custom Connector

[trevrobwhite]

I'm a lot happier creating a script in Pyhton than writing a custom connector in M, python also has the advantages of being able to debug and step through each line of code.

So I wanted to check is there any downside to pasting a long Python script into PowerBI and executing this as opposed to creating a custom connector?  Will the server have any issue refreshing it when it's published?

Many thanks.

[lbendlin]

Python scripts tend to be quite a bit slower than M code.

Also keep in mind that as soon as you say Python (or R) and Power BI Service in the same sentence you are doomed to require a personal gateway.

[trevrobwhite]

Ah, so Python scripts require a personal gateway is that right?

[lbendlin · Accepted solution]

If you want to share on the service, yes.