Forum Discussion
Use Python in Power BI connecting directly to my Power BI dataset
Tks for your answer, lbendlin! Let me see if I understood:
a) The best way to create a new table or a calculated column, using Python scripts, is in Power Query.
b) In Power BI desktop (after applied the ETL steps from Power Query), Python scripts should be used only to render a chart, diagram, table etc. Not to add tables or calculated columns to my tables.
c) About your NOTE 2. If I publish or share my report, the Python script will only run if I have a Personal Gateway.
Can you please add your comments to these statements?
Super UserThat is available for Power Query (where you can run Python scripts against the appled steps) and for the User interface as well where you can add a Python visual to your report.
NOTE 1: The Python visual MUST render something. Just running a script will not be sufficient.
NOTE 2: If you want this to refresh in the service then a Personal Gateway is mandatory.
Tks for your answer, lbendlin! Let me see if I understood:
a) The best way to create a new table or a calculated column, using Python scripts, is in Power Query.
b) In Power BI desktop (after applied the ETL steps from Power Query), Python scripts should be used only to render a chart, diagram, table etc. Not to add tables or calculated columns to my tables.
c) About your NOTE 2. If I publish or share my report, the Python script will only run if I have a Personal Gateway.
Can you please add your comments to these statements?