Can't connect to azure analysis services with python and azure function using azure active directory.

Gökhan Demirci 40 Reputation points
2023-05-10T12:15:18.22+00:00

Hi,

iam trying to connect azure analysis services to query a tabular model using an azure function which is coded with python. The authorization is working through azure active directory and i setup oauth in my python script with token requests. The connection String is setted up properly.

Ther error code (400 bad request, user_realm_discovery_failed) seems generic so i cant debug properly.

What works with similar setup is to query a ssas model but i cant figure out why its not working with a azure analysis services model (aas model)

Kind regards

Gökhan

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
676 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,642 questions
{count} votes

Accepted answer
  1. Ryan Hill 27,026 Reputation points Microsoft Employee
    2023-05-16T21:59:58.69+00:00

    @Gökhan Demirci , I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that the question author cannot accept their own answer, they can only accept answers by others, I'll repost your solution in case you'd like to Accept the answer.

    • You determined you issue was the result of insufficient permissions and the use of wrong ADOMD (ActiveX Data Objects for Multidimensional Data) version.
    • You were using version 13 and switched to version 16.
    • You adjusted your Function app's rights to access the tabular model on your Analysis Services instance.
    0 comments No comments

0 additional answers

Sort by: Most helpful