Accessing a local file in a Power Query custom connector

[shripathi-kamath]

I have developed a sample connector that uses OAuth2 authentication to get a JSON document from a web server.

It works fine, end-to-end when I have the OAuth2 authentication parameters (tenant_id, client _id) hard-coded.

I then tried to place the authentication parameters in a local JSON file. C:\Users\Public\Documents\Myfolder\MyConfig.json. The goal is to use one connector to get data from multiple server by changing the Entra ID parameters.

I am unable to read from this file. Access to local files is apparently not permitted.

I keep getting an exception: [microsoft.mashup.engine.interface.unpermitted resourceaccessexception] anytime I use

Json.Document(Text.FromBinary(File.Contents(location)))

to get the fields in the MyConfig.json file

Any ideas on how to get around this problem, or if it even possible?