SQL Cube connection error

[DanCasSan]

Dear community:

I am having trouble connecting to a cube I have in SQL from Power BI.

Currently, I connect to the server through a VPN and, I have managed to connect to the cube by Excel; However, when I want to do it from the Power I get the following error:

"Details:" Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "

How could I fix this error and connect?

Regards,

[v-lili6-msft]

hi @DanCasSan 

Here are similar posts, you could refer to them, these should help you:

https://community.powerbi.com/t5/Desktop/Not-able-use-data-source-configured-on-on-premises-data-gat...

https://community.powerbi.com/t5/Desktop/Connect-to-SQL-server-with-Localhost-via-UNIX-socket/m-p/10...

https://community.powerbi.com/t5/Desktop/Can-t-connect-to-SQL-server/m-p/196782

Regards,

Lin

[DanCasSan]

Hi @v-lili6-msft.

None of the links that you have shared have helped me with the error, I tried to see if the connection was correct and I checked yes. I was able to connect to a table on the server, but not to the cube that I created.

Regards,

[v-lili6-msft]

hi @DanCasSan 

If you still have problem, I would suggset you create a support ticket to get further help.

Regards,

Lin

[Greg_Deckler]

I Named Pipes enabled on the SQL Server?