Python Power BI Integration

[Anonymous]

Hey All,

Currently I have downloaded excel file from SQL server and prepared the reports in PBI desktop on my machine using some python libraries like pandas, stats models. I have python installed on my machine and hence don’t face any issue.

Now, in the next step I want to link SQL directly with PBI(this part I know), and also perform python functions in the server itself i.e. w/o the interaction of python libraries path directed to my C drive. Is this possible. If yes, please provide guidance.

Thanks. 😊

[amitchandak]

@Anonymous , refer  for python

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts
https://en.blog.businessdecision.com/how-to-use-the-python-integrator-in-powerbi/
https://towardsdatascience.com/using-python-in-power-bi-ee95a6b71443
https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/

[Anonymous]

Hey, this is i think program that works when you have python installed in the local system...i want to do run the program in the server after fetching data directly from SQL.

Thanks

Sahil

[v-deddai1-msft]

Hi @Anonymous ,

Are you trying to run python script in power bi? Please refer to  https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-in-query-editor

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai