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:
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?
I am able to connect with Basic Authentication without issue. However, we have RLS enabled on our AAS Model so I need the logged in user to connect as themselves, not the hardcoded user in the report datasource Basic Authentication.