topic Re: Python Script vs Custom Connector in Developer

Python Script vs Custom Connector

Anonymous — Wed, 09 Feb 2022 12:15:39 GMT

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.

Re: Python Script vs Custom Connector

lbendlin — Fri, 11 Feb 2022 03:38:36 GMT

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.

Re: Python Script vs Custom Connector

Anonymous — Fri, 11 Feb 2022 09:10:45 GMT

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

Re: Python Script vs Custom Connector

lbendlin — Fri, 11 Feb 2022 12:10:09 GMT

If you want to share on the service, yes.