Unexpected Multiple Requests from Power BI Connector

Hey v-kpoloju-msft,

thanks for your input. I'll try that stuff and check your links, but I already have a question:

You mention the "ResourcePath" option. I tried that, but I always got an error message that the ResourcePath option isn't a valid Web.Contents option. Google said that this error message should only happen in Visual Studio, but I keep hitting that same error message in Power BI. What am I doing wrong?

Hey v-kpoloju-msft

I tried to look into your suggestions:
First of all I rechecked the "ResourcePath" option. I switched from "Visual Studio 2019" to "Visual Studio Code" and I did not get the error message that "ResourcePath" is an invalid option. I was hopeful, and since I also updated my Power BI to the newest version I was really hoping that I'm making some progress here. But when I tried the new connector in the updated Power BI version I was hitting the same result: "ResourcePath" is an invalid option.

Checking the Web.Contents link you posted above I saw that "ResourcePath" isn't mentioned there as a possible option. In the error response I got in Power BI there are listed possible options for "Web.Contents". Of course no "ResourcePath" was mentioned there, but I found a "Resource" parameter (which is also not listed in the documentation). So I thought maybe the option name just changed. I tried "Resource" instead of "ResourcePath" and my connector worked again in Power BI - but unfortunately the same number of requests are shown in the log 😕
Next thing I tried to wrap the download function. I checked the links again, but couldn't find any examples or help how to do so. But with a little external help I came up with something like this:

loadCsvFile = (relativePath as text, token as text) =>
    let cachedLoadCsvFile = () =>
        let
            _token = if debug <> null then Diagnostics.Trace(TraceLevel.Information, "loadCsvFile " & relativePath & " called with token: " & token, token) else token,

            response = Web.Contents(MyConnector.StorageUrl, [
                RelativePath = relativePath,
                Headers = [
                    Authorization = "Bearer " & _token
                ]
            ]),
            csv = Csv.Document(response, [
                Delimiter = ",",
                Encoding = 65001,
                QuoteStyle = QuoteStyle.Csv
            ]),
            table = Table.PromoteHeaders(csv)
        in
            table
    in
        cachedLoadCsvFile;

This actually helped a bit - all the download requests which are made during the navigation table is loaded are gone. This reduces the number of file requests from 8 for every single file to 6. The only thing that unsettles me a bit is that in the navigator the files are now displayed as "functions" and not as "tables" anymore (just to be clear: I'm only talking about the icon here). But I couldn't see any difference in the actual data which was imported, so I hope this is fine.
Of course I would love to reduce the number of requests more than that. So feel free to add more suggestions 🙂

Regards,

Scheißy