Analysis services error when viewing report on power bi report server
When trying to view reports uploaded to an instance of Power BI Report Server that previously opened without error in the Sept 2022 release of Power Bi Desktop, receive the following error: We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.: Request ID: 944ea27c-3109-15c3-0d0c-50a1ca6dd1b5 Time: Thu Oct 13 2022 11:01:47 GMT-0600 (Mountain Daylight Time) Service version: /powerbi/libs There is no connection string explicitly called out in the report; we are using Windows credentials. Any ideas what's going on here? Lee
On premise data gateway, invalid username or password error for SSAS
Hi everyone, I try to make a connection to my SSAS cube via Standard on-premise data gateway and I always get an invalid username or password error! Here are the configuration that I did after reading troubleshooting doc: The gateway service run with my windows account, this acccount is administrator on the server. My UPN and windows account are set correctly in our organization AD. TGGAU is set correctly for our domain. The command "whoami /upn" return the good email adress used to connect to PowerBI service. The SSAS server belong to the organization domain. All the other connection type like Sql server, Excel file are working properly. We use Sql Server 2019 Enterprise version. When I try to run a report (with SSAS as datasource correctly configured) in Power BI service, I see the trace on SSAS (profiler) and I see that the NTDomainName and NTUserName are passed correctly to SSAS, but an invalid username or password message is generated. In SSAS, my account is a server administrator and I add the account as full control role for the SSAS database. We use a specific port to access the SSAS server, not the default one. In SSMS, when I try to connect to SSAS with the Additionnal Connection Parameters : [email protected], I am not able to connect, it generate the same error as I have with the gateway. What am i missing? It's been quite a while that I am trying to figure out what I do not do correctly. Thank you for your help, Gervais.
Cannot deploye metadata. Reason: An error occured while connecting to the server.
I am using Visual Studio and from there I want to create a cube by using the Service Analysis Model Tabular with the help of connecting to the SQL Database. I have used all the connectios correctly. But, In Model Tabular Designer I opted Integration Service instead localhost and tried with the localhost as well. But, either of the options have not made me overcome this issue. Please let me know the anser how to
Error connecting to Analyis Services-Server from Power BI Report Server
Hi We have a Power BI report, uploaded to Report Server, that is using DirectQuery (Live connection) to SQL Server Analysis Services-Server. So the flow is like this: Power BI Report server (DirectQueyr) <--> Analysis services server (with user Impersonation) <--> db server. The 'Data source' - connection property is set to Windows-Authentication. When we specify a fixed user (providing user name and password) for the the data connection, the report works without any error. But when the user is changed to 'As the user viewing the report', the report will end up with the following error (sorry, the snapshot of the error message is in German; basically it is indicating problem connecting to Analysis services server). --------------------------------------------------------------------------------------------------- Unerwarteter Fehler. Unerwarteter Fehler. Wiederholen Sie den Vorgang später. Versuchen Sie es später noch mal, oder wenden Sie sich an den Support. Geben Sie die folgenden Details an, wenn Sie sich an den Support wenden. Es konnte keine Verbindung mit dem Analysis Services-Server hergestellt werden. Stellen Sie sicher, dass Sie die Verbindungszeichenfolge richtig eingegeben haben.: Anforderungs-ID: 8d5b33a1-0c32-ed5a-412a-caf261ef4cdd Zeit: Thu Feb 27 2020 15:48:03 GMT+0100 (Mitteleuropäische Zeit) Version: 15.0.1102.371 --------------------------------------------------------------------------------------------------------------------------------------------- At this point I don't know what else to check as the possible cause of this 'connect to Analysis server' error when using the 'As the user viewing the report'. Because when I specify a specific User name and password with the 'Using the following credentials' option the report doesn't encounter the error/problem of using the 'As the user viewing the report' option.