Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Python Script vs Custom Connector

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.

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        4 years ago

        If you want to share on the service, yes.