Failed to set credentials to power bi dataset online using azure storage account SAS.

[walid140891]

Hello Power BI Pros,

It's a story full of details, we have a power bi file which is connected to an azure blob storage and retrieves the containers inside it by customer id:

the pbix file later will be given to our customers and in order to force them to only access their data and prevent them from accessing all customers data and we have added a SAS (Shared access signature) and we disabled the public access to the Azure storage account.

That works fine until we publish the file, of course we need to set the dataset credentials, and since we also created a SAS for the storage account itself (to avoid giving the customers the access key) we chose to connect using the SAS token, but it always refused it even when public access is enabled with the correct privacy level, and we can only connect using the Access Key:

Your help is much appreciatable.

[v-yueyunzh-msft · Accepted solution]

Hi , @walid140891 

According to the screenshot you provided with detailed error information, I found this error record for this error operation in the Microsoft background database:

Microsoft.PowerBI.ServiceContracts.PowerBIRemoteServiceException: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: DM_GWPipeline_Gateway_InvalidConnectionCredentials

I think this is a simple gateway to access this Azure storage account cloud data source when there is an incorrect credential error, if you can first reveal why you have to use the gateway to configure the data source credential connection for this Azure storage account cloud data source? If it is convenient, you can try to click "Edit credential" directly in "Data Source credentials" to enter the corresponding credentials for the Azure storage account cloud data source, let the data source definition take effect, and check again whether the refresh was successful?

For the type of credential entered, I think both the SAS token and the key can be tried:

Manage account access keys - Azure Storage | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[GilbertQ]

Hi @walid140891 

What happens if you change the privacy level to Organizational?

Also when I have configured this in the past I have left all the default options in Azure blob storage. Could there be some setting on the blob storage causing this to fail?

I would suggest trying with all the default settings in Azure Blob storage and then make one change and test until it fails so you know where the error is?