Unexpected Multiple Requests from Power BI Connector

Hey  Scheißy ,

You are absolutely right Power Query’s engine does not allow Web.Contents to run in shared/global scope, which is why you saw the UnpermittedResourceAccessException. You can try:

1. Use Lazy Evaluation + Let-Caching Inside MyConnector.Contents

Move the getAuthResponse() call once insideMyConnector.Contents, and reuse thetoken within the scope of the same function using a let block:

shared MyConnector.Contents = () =>
    let
        auth = getAuthResponse(),
        token = auth[token],

        profilesData = loadCsvFile("11b567...", token),
        effectsData  = loadCsvFile("116fc8...", token),
        reportsData  = loadCsvFile("02a0a2...", token),

        source = #table({ "Name", "Data" }, {
            { "Profiles", profilesData },
            { "Effects", effectsData },
            { "Status Reports", reportsData }
        }),
        navTable = Table.ToNavigationTable(source, { "Name" }, "Name", "Data", "ItemKind", "ItemName", "IsLeaf")
    in
        navTable;

2. Avoid Nested Diagnostics.Trace Causing Multiple Evaluations

In Power Query, anything inside Diagnostics.Trace may get evaluated more than once (once for value, once for metadata). You can reduce this by moving trace logging after evaluation, or removing trace for heavy operations like getAuthResponse() and loadCsvFile() during testing.

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam