Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.'
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.'