Custom connector failed to autheticate "Please specify how to connect"

[walid140891]

Hello PBI Developers,

We are trying to connect to a specific azure blob storage container using a custom connector, because the official blob storage connector can show the client all the containers inside that storage account. the M code is like below:

// This file contains your Data Connector logic
section AzureBlobStorageContainerConnector;

[DataSource.Kind="AzureBlobStorageContainerConnector", Publish="AzureBlobStorageContainerConnector.Publish"]
shared AzureBlobStorageContainerConnector.Contents = 
    let
    Source = (CustomerGuid as text) => 
    let
        Source = AzureStorage.Blobs(
            Text.Combine({"https://xxxpowerbistorage.blob.core.windows.net/", CustomerGuid}) 
            ),
        #"Parsed JSON" = Table.TransformColumns(Source,{{"Content", Json.Document}})
    in
       Source
in
    Source;

// Data Source Kind description
AzureBlobStorageContainerConnector = [
    Authentication = [
        // Key = [],
        // UsernamePassword = [],
        // Windows = [],
        //Implicit = []
        Anonymous = []
    ],
    Label = Extension.LoadString("DataSourceLabel")
];

// Data Source UI publishing description
AzureBlobStorageContainerConnector.Publish = [
    Beta = true,
    Category = "Other",
    ButtonText = { Extension.LoadString("ButtonTitle"), Extension.LoadString("ButtonHelp") },
    LearnMoreUrl = "https://powerbi.microsoft.com/",
    SourceImage = AzureBlobStorageContainerConnector.Icons,
    SourceTypeImage = AzureBlobStorageContainerConnector.Icons
];

AzureBlobStorageContainerConnector.Icons = [
    Icon16 = { Extension.Contents("AzureBlobStorageContainerConnector16.png"), Extension.Contents("AzureBlobStorageContainerConnector20.png"), Extension.Contents("AzureBlobStorageContainerConnector24.png"), Extension.Contents("AzureBlobStorageContainerConnector32.png") },
    Icon32 = { Extension.Contents("AzureBlobStorageContainerConnector32.png"), Extension.Contents("AzureBlobStorageContainerConnector40.png"), Extension.Contents("AzureBlobStorageContainerConnector48.png"), Extension.Contents("AzureBlobStorageContainerConnector64.png") }
];

As you can see the the Authentication has been set to Anonymous, because I updated the access policy of the azure blob container to accept anonymous access, however when I load the mez file and connect using PowerBI Desktop I face this error:

NOTE: is also occures when I use KEY with the storage account key or even implicit authentication options!

Your help is much appreciable!

[Anonymous]

Hi @walid140891 ,

I found this in the document Troubleshooting the Power Query Web connector - Power Query | Microsoft Learn:  

Every use of the Web connector to get data from an HTML page requires the use of an on-premises data gateway when published to a Cloud service, whether it's Power BI Service for datasets or dataflows, or Power Apps for dataflows. (Currently, Dynamics 365 Customer Insights doesn't support the use of a gateway.)

If you receive a Please specify how to connect error message when attempting to connect to an HTML page using the Web connector, ensure that you have Internet Explorer 10 or later installed on the machine that hosts your on-premises data gateway.

Hope this document could help you

Morty

[walid140891]

Hello @Anonymous ,

Thank you for your reply, I took a look at the link you sent to me, but as mentioned in the code below, what I'm trying to retrieve a document saved in the blob via a web link, so it's not exactly an HTML page, nevertheless I checked the internet explorer and it's installed in my pc. but the issue is not solved yet. I thank you anyway for your response!