Forum Discussion

numersoz's avatar
numersoz
Icon for Helper III rankHelper III
6 years ago
Solved

External Data Source Python Script

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' ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

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

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

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