Firewall Error

[CubedFluidity]

In Excel, I save the path to Sharepoint and I retrieve it using Excel.CurrentWorkbook(). 

I put all my excel a variables into the xl_Val Record. 

let

    SharepointBaseURL = Text.From(xl_Val[SharepointBaseURL]),
    SP_GetFile = SharePoint.Files(SharepointBaseURL, [ApiVersion = 15])

in

    SP_GetFile

I get the following error. 

All my sources are set to organizational. The Sharepoint is not shown in Local Data Sources, but it is in by global sources. I tried to buffer the variable, but no luck. 

The query dependencies do not show the Sharepoint Query

If I use Paramaters for the Sharepoint URL, the dependencies look different. 

Is there any way to get the URL from Excel and use it to get the sharepoint files? @pqian 

[CubedFluidity]

Thanks Jimmy, 

I am going to keep firewall setting and will use a parameter as input. 

Erik

[Jimmy801]

Hello @CubedFluidity 

you have to include this query "xl_Val[SharepointBaseURL]" also into your main query.. meaning not referencing it only.

Another solution should be to disactivate the firewall in your options

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy