Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

0
mnabil_cee

Power BI Service | Refreshing a dataset that uses a Python script fails

Submitted by on ‎06-23-2022 11:34 PM

I have a Power BI report that pulls a csv file from a SharePoint site and then I use Python to transform the queried file using pandas library. On my desktop everythin works perfect. However, when I publish my report to the service and try to refresh the dataset either Manually or by scheduling. Refresh fails with the following error, "Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."

I even tried to use only python to generat a very simple dataframe from a blank query to narrow down the problem, the same issue happens again. I used this single line of code : df = pd.DataFrame({'col1':[1,2,3],'col2':[4,5,6],'col3':[7,8,9] })

The limitations of using a python script in the service isn't clear in the documentation. It only says "In just a few steps, you can run Python scripts and create a data model. From this model, you can create reports and share them on the Power BI service."

Status: Delivered
See more ideas labeled with:
5 Comments (5 New)
Comments
klinejordan
Advocate II
Advocate II
‎06-24-2022 07:43 AM

See the limitations about python scripts refreshing in the service here: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-in-query-editor#creating-visua...

 

You need to install a Personal gateway and have python installed on that machine as well. 

mnabil_cee
Regular Visitor
‎06-24-2022 01:12 PM

Hi klinejordan,
Thank you, but this is not my case. The gateway is needed in the example in the link because the python was used with a file located on the local machine. However, in my case I have no local files in my dataset.

klinejordan
Advocate II
Advocate II
‎06-24-2022 02:21 PM

Not sure about that, I think you need a Personal Gateway regardless of what you're doing in python because the service needs a python runtime location to do the processing. But I could be wrong. 

Anonymous
Not applicable
‎06-30-2022 11:06 PM

Hi @mnabil_cee ,

 

Totally agree with @klinejordan , please try using the personal gateway to see if it solves your problem.

 

Best Regards,
Community Support Team _ Caitlyn

slru
New Member
‎03-04-2023 08:08 PM

I have a similar problem.  If I install the personal gateway and publish, will the other users be able to access and interact with the report/dashboard ? Do they need to do anything else on their side to get access? They are just consumers of the report and not developers.

 

If this is not possible with Power BI, do you know of other products that provide this feature? Thanks.

 

Idea Statuses