Azure Analysis Services - error when processing blob storage data

Matthew 121 Reputation points
2021-10-01T12:44:18.527+00:00

Hello,

I'm facing an issue regarding access to Blob Storage Container from Azure Analysis Server Instance. I've created a tabular model that pulls the data from Blob Container, but when I'm trying to process the data from the container in SQL Server Management Studio, I receive following error:
*Failed to save modifications to the server. Error returned: 'The credentials provided for the AzureBlobs source are invalid. The exception was raised by the IDbCommand interface. *

I'm sure that credentials provided are correct, because I'm able to connect to container in the first place using them. Additionally, blob conatiner does not have firewall rules set up. We've tried to add analysis services ip address to blob container firewall anyway, but without success.

I'll appreciate any help.

Best regards,
Mateusz

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,349 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Yan Linn Naing 0 Reputation points
    2023-02-10T23:58:39.8233333+00:00

    Hi Matthew,

    May I know how did you figure out the issue ? What was the root cause and the fix ?
    I'm currently facing the same issue as yours. Thank you.

    0 comments No comments

  2. Yan Linn Naing 0 Reputation points
    2023-02-11T00:04:26.4733333+00:00

    following the comments.

    0 comments No comments