problem with loading tabular data set

[arnoldinho]

Describe the problem

Error 10: A connection problem arises between the server and Bravo.
A connection cannot be made. Ensure that the server is running.

Bravo version

1.0.2 (1.0.8480.21768)

Tabular model

Power BI Desktop, import mode

Power BI

SQL Server 2019, SSAS 1500

Steps to reproduce the behavior

1. Analyze model
2. Click '+'
3. Click one of datesets in "powerbi.com"
4. error

Additional context

No response

Screenshots

Anything else ?

Trace Id: 00-f78c416ea6577671c745a3f6f175b16f-9cc5ea06ac5546cc-00

[arnoldinho]

[albertospelta]

Hi @arnoldinho, is the SQL Server Analysis Services instance on-premises or in the cloud on a virtual machine?
The error appears to indicate a network connection issue.

[arnoldinho]

@albertospelta on - premises instance

[albertospelta]

@arnoldinho, Bravo connects to the SSAS instance using the connection string configured for the gateway in the PowerBI service. Could it be that this connection string contains a hostname/endpoint in the Data Source parameter that is unreachable from the local network?

In the following example I'm using an Azure AS instance but the configuration should be similar to a connection to an on-prem SSAS instance.

Here my connection string is Provider=MSOLAP.5;Data Source=asazure://centralus.asazure.windows.net/bravosdev:rw;Initial Catalog=adventureworks;Cube=Model and my Data Source is asazure://centralus.asazure.windows.net/bravosdev:rw

Is the datasource in your connection string a valid hostname or IP address that you can use to connect to the SSAS instance via SQLServer Management Studio?

please blank out or obfuscate any sensitive strings in case you want to share any connection info/settings