Forum Discussion

Regular Visitor

1 year ago

Solved

Use Python in Power BI connecting directly to my Power BI dataset

I want to use Python in a Power BI dataset that has already been cleaned (ETL via Power Query). I don't want to connect Python to an external dataset or database, but to the dataset that is ready in ...

Need Help

WMM
1 year ago
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?

WMM

Regular Visitor

1 year ago

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?