External Data Source Python Script

[numersoz]

Hi,

I'm connected to Sharepoint to get data from Excel sheets. I'm trying to run a Python script on this inside Power Query.

However I get the below error:

"Formula.Firewall: Query 'CapEx' (step 'Run Python script') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."

I've tried to make the data source privacy setting to none or public and that didn't help. 

Does anyone have any suggetions? I need to be able to run Python on source inside Sharepoint.

[v-frfei-msft · Accepted solution]

Hi @numersoz ,

All Python data source settings must be set to Public, and all other steps in a query created in Query Editor must also be public. To get to data source settings, in Power BI Desktop select File > Options and settings > Data source settings.

From the Data Source Settings dialog, select the data source(s) and then select Edit Permissions... and ensure that the Privacy Level is set to Public.'