Can not open report with a failing connection

[MarcoDekker]

Hi all

On a server i have PowerBI pointing to a SSAS cube using a live connection. 

On some laptops i installed PowerBI desktop and enable users to create new reports on that cube. That works well. But..

When i copy a report created on the server, towards the laptops, they are unable to open the report: 

I can not even change or view data connections.  It simply does not open the report. How to get this done?

[v-xinruzhu-msft · Accepted solution]

Hi @MarcoDekker 

1. Have you configured the gateway for the ssas data source on the server and added the data source to the gateway, if not, please consider installing the gateway on the notebook first and then adding the gateway and adding the data source on the service. You can refer to the link below.

Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn
2. You can try to connect to the data source with SSMS on your laptop. If you fail to connect, please check whether the data source is affected by the firewall. You can refer to the following link.

https://learn.microsoft.com/en-us/analysis-services/instances/connect-from-client-applications-analy...

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.