Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Report Server connect to Azure Analysis Services How to configure Data Source?

Our RS version is September 2022. We've built a report that connects live to our AAS instance and built some additional measures in the report. Works great in PBI-RS desktop. What is the correct way ...
AAS
Data Source Configuration
Report Server + AAS
kanielwang's avatar
kanielwang
Regular Visitor
3 years ago

The AAS does support Windows Authentication. AD FS is required. I successfully accessed my AAS data model by using my local domain user account. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Aha, so if my company uses Okta as our federated services provider, then it seems I'm out of luck here? Thanks for your response. 

    • d_gosbell's avatar
      d_gosbell
      Super User
      3 years ago
      Anonymous wrote:

      Aha, so if my company uses Okta as our federated services provider, then it seems I'm out of luck here? Thanks for your response. 

      I think you should be able to use Okta with the Power BI cloud service, but for the on-prem Report Server you might need to code your own authentication provider and I'm not sure how that would interact with the scheduled refreshes

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        d_gosbell thank you for this insight. I think we'll just end up getting pro licenses for these folks and publishing up to the PBI service. My other option is to rebuild the entire report and go after the SQL database that feeds the AAS cube as the data source instead.