search

sql-bi / Bravo

Bravo for Power BI
MIT License
343 stars 88 forks source link

problem with loading tabular data set #647

Open arnoldinho opened 1 year ago

arnoldinho commented 1 year ago

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

image

Anything else ?

Trace Id: 00-f78c416ea6577671c745a3f6f175b16f-9cc5ea06ac5546cc-00

arnoldinho commented 1 year ago

image

albertospelta commented 1 year ago

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 commented 1 year ago

@albertospelta on - premises instance

albertospelta commented 1 year ago

@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

image