Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
LohitaAggarwal
Frequent Visitor

Python in Power Bi Service

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.

1 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

View solution in original post

7 REPLIES 7
bim1wz1
New Member

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

apods1979
Helper I
Helper I

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

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
Not applicable

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 ?

@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. 

 

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

Anonymous
Not applicable

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?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Top Solution Authors
Top Kudoed Authors