Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI live connection error

Hi, 

I get a problem to connect to the server after was working on the project for a long time.

I get a message: 

"We encountered an error while trying to connect.
Details: We couldn't connect to the Analysis Services server because the connection timed out or the server name is incorrect."

 

******

Before this error i get another one :

"An error occured while loading the model for the item or data source 'OpenConnectionError'. Verify that the connection information is correct and that you have permission to access the data source"

 

I've checked the server and that's fine, working for other instances.

Please help to resolve that.

Thanks,

  • Anonymous's avatar
    Anonymous
    7 years ago

    Thank you for your solution. The problem was found and it happend because of the server which was down for some reason.

4 Replies

  • Anonymous is there change in user credentials, you can clear the data source credential by File -> Options and Settings -> Data Source Settings and select you source, clear/edit the credentials

    • Anonymous's avatar
      Anonymous
      Not applicable

      I use windows credentials and didn't change them at all. 

      It happens to other users in the company also

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Anonymous,

     

    Please check if any change made on Analysis Services server side. Whether the SSAS server restrict the outside access? You can try to connect to the same data model from other tool, like Excel to test whether it works. Also, please check whether you hit the limitations of SSAS live connection. 

     

    Regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for your solution. The problem was found and it happend because of the server which was down for some reason.