topic Connect PowerBI with SAS: could not establish the connection to the server in Administration and Deployment

Connect PowerBI with SAS: could not establish the connection to the server

MariaD — Tue, 17 Oct 2023 12:10:41 GMT

Hi Guys,

We have SAS installed on Linux, 9.4M7 on a grid. We have some users that connected from PowerBI to SAS using OLE DB connection string for a while. Yesterday, without any change on the SAS server, the connection string started to fail to connect.

We tested the IOM Bridge connection using SAS Integration Technologie Wizard and the same error occurred.

We don't have any problem connecting using SAS EG. We tested in several users' machines with several logins and the same error appeared.

Any idea?

Regards,

Re: Connect PowerBI with SAS: could not establish the connection to the server

SASKiwi — Wed, 18 Oct 2023 02:28:10 GMT

Can you post the connection string you are using? Also you can test the Workspace Server IOM bridge connection in SAS Management Console by right-clicking on the connection and selecting Test Connection:

Re: Connect PowerBI with SAS: could not establish the connection to the server

MariaD — Wed, 18 Oct 2023 12:26:26 GMT

Hi guys,

After some tries, we connected using PBI desktop but not PBI Gateway (personal mode). The string is the same, but in PBI gateway request again the credentials and timeout occur. We found this Microsoft note, but even when selecting anonymous authentication the error persists.

String:

provider=sas.IOMProvider.9.44;data source='iom-name://SASApp - Logical Workspace Server";sas cell cache size=10000;sas machine dns name=XXXXX;sas port=8591;sas protocol=2;sas server type=1;sas metadata user id=YYY;sas metadata password=ZZZZ;sas metatada location:RRRRRR:8561

Regards,

Re: Connect PowerBI with SAS: could not establish the connection to the server

SASKiwi — Wed, 18 Oct 2023 19:18:16 GMT

I'd suggest progressing your issue with SAS Tech Support as it looks like more troubleshooting is required.