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 to configure the Data Source in the Manage/Data sources screen? The AAS cube has a Users role with an Azure Active Directory group in that role. Under the credentials, the only options are Windows Authentication and Basic Authentication. When I set the credentials to Windows and select the radio button for "As the user viewing the report" I get the error message "We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly." When I change it to "Using the following credentials", enter a Non-MFA account and password that is a member of the user group, and check the box that says "Log in using these credentials, but then try to impersonate the user viewing the report", I get the same error. When I uncheck the "Log in using these credentials but then..", same error. When I test the connection, I get "Unable to obtain authentication token using the credentials provided" When I change the authentication type to Basic Authentication and provide a username and password, test the connection, I also get "Unable to obtain authentication token using the credentials provided". I've verified that I can access the AAS instance from the on-prem report server using my own credentials and MFA. It shouldn't be that hard to connect up to AAS in a power BI model from report server. Has anyone been able to do this succesfully? Thanks in Advance!