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

[MariaD]

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,  

[SASKiwi]

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:

[MariaD]

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,

[SASKiwi]

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