Python in Power Bi Service

[LohitaAggarwal]

I understand that Python integration is limited to Power Bi Desktop at the moment. But has Microsoft released any tentative date to incorporate it in Power Bi Service?
I have a requirement to use Python in my dashboards but can not use it unless we are sure, its going to be available in Service in near future.

[bim1wz1]

Hello, it is year 2022, and I see the same error message. Is this issue is finally solved? What is the solution?

[apods1979]

This code work for me in PBIX!!!
But you have to install packages in your PC....

let
Source = Python.Execute("import pandas as pd#(lf)import yfinance as yf#(lf)import investpy#(lf)#(lf)TickerList = ['A1ZN34.SA','A1ZN34' ] ]#(lf)data = pd.DataFrame(data,columns=['country', 'name', 'full_name', 'isin', 'currency', 'symbol'])#(lf)#(lf)df_Tickers = investpy.get_stocks(country='Brazil')#(lf)df_Tickers = df_Tickers.append([data], sort=False)#(lf)df_Tickers['AcaoFull'] = df_Tickers['symbol']+'.SA'#(lf)df_Tickers['AcaoName'] = df_Tickers['AcaoFull']+' - '+df_Tickers['name']#(lf)df_Tickers.sort_values(by=['symbol'], inplace=True, ascending=True)#(lf)df_Tickers.drop_duplicates('AcaoFull') #(lf)df_Tickers['IndexCol'] = range(1, len(df_Tickers) + 1)#(lf)#(lf)##dataset = yf.download(tickers=TickerList , period='1y')#(lf)dataset = yf.download(tickers=TickerList , start='2020-01-01', end='2021-12-31',progress=False)#(lf)#(lf)dataset = dataset.stack().reset_index().rename(index=str, columns={""level_1"": ""Acao""}).sort_values(['Acao','Date'])#(lf)dataset = dataset.reset_index() #(lf)dataset = dataset.set_index([dataset.index])#(lf)dataset = dataset.fillna(0) #(lf)dataset = pd.merge(dataset, df_Tickers[['AcaoFull','IndexCol']], how='left', left_on=['Acao'], right_on = ['AcaoFull'])#(lf)"),
dataset = Source{[Name="dataset"]}[Value]

in

dataset

[rafaelmpsantos · Accepted solution]

Yes, like R scripts is now avaliable in power bi services, Python will be avaliable soon. 

Remember you will need a personal gateway.

If it solve your problem, please mark as solved and give your positive feedback.

Rafael Mendonça
MCSA Bi Reporting
www.youtube.com/rafaelmendonca

[Anonymous]

Hey Rafael, I tried using Python script in the Power BI desktop, it worked fine , but when tried to publish the same report in the service it is giving this error - ' Python visuals are currently disabled in your organization'. what could be the possible reason ?

[LohitaAggarwal]

@rafaelmpsantos Thanks for the prompt respons!

Is there a way to know the Release Date from Microsoft? As we will not be able to use Python in our dashboards, if its not integrated with Service in this year. 

[rafaelmpsantos]

Maybe this month... Will be a very hudge update on power bi this month

[Anonymous]

Is there an update when Pyhon is available in Power BI Service? Also, are there any plans to include interactive plotting packages  such as plotly?