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!
Error connecting to Azure Analysis Services from Power BI Report Server
I have created a report in Power BI Desktop (RS edition) and connected it to our Azure Analysis Services Model. I connected using my Microsoft Account (AAD?) and can run the report without issue. However, once it's published to our Report Server, when I access it I receive the error: Couldn't connect The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly. Unable to obtain authentication token using the credentials provided. If your Active Directory tenant administrator has configured Multi-Factor Authentication or if your account is a Microsoft Account, please remove the user name and password from the connection string, and then retry. You should then be prompted to enter your credentials. When managing the Data Source within Report Server, I only have Windows Authentication or Basic Authentication as an option. Do I need to edit my connection string for the AAS server?