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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
gabrielmabelly
Regular Visitor

Online refresh of PBI report that includes python script

Hi everyone, I've got an issue, I created a report which pulls data from a web api, after that I do some data transformation, some of which include a python part because I didn't manage to do process the data using power query only.

My issue is that the python script works fine using PBI Desktop but when I publish the report online it doesn't refresh, the whole purpose of this report is that people can access it from anywhere and that it is updated automatically and this last part is an issue because of python.

 

Did anyone have the same issue ? If so how did you manage to make it work ?

 

My python script looks like this :

import pandas as pd

pivoteddata = dataset.pivot_table(index=['RecordedData.Items.Timestamp', 'BAC'], columns='TypeData.2', values='RecordedData.Items.Value', aggfunc='first').reset_index()
print (pivoteddata)

 

Thanks in advance !

2 REPLIES 2
Jonvoge
Solution Supplier
Solution Supplier

Hi gabrielmabelly.

 

Unfortunately this is a current known limitation of using R and Python in Power BI. The only way around this is to install and use a personal gateway, to create a connection to your local machine from the Power BI Service: Troubleshoot Power BI gateway (personal mode) - Power BI | Microsoft Learn

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.

Hi Jonvoge,  from what I saw personnal gateway doesn't allow sharing, do you know by any chance if enterprise allows python connection ?

Do you have any workarround that would allow me to refreh the dataset while keeping the processing done the way it is with python (I don't mind using power query I just didn't find a way to process data the way I want)

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors