Forum Discussion

Frequent Visitor

8 years ago

Problems connecting to SSAS through On Premises Gateway

Keep getting there was a data source error, Please contact the gateway administrator

Microsoft Employee

8 years ago

Are you the owner of this report?

Please check whether the gateway is online. If it is offline, you will see below error message, and it will fail to refresh dataset.

Also, please check the data source connection. Make sure the gateway can connect to SSAS successfully.

Best regards,
Yuliana Gu

Frequent Visitor

8 years ago

Thanks Yuliana

I have checked and i can see that my gateway is online and its connecting ssas of my machine as well

vishalc
Frequent Visitor
8 years ago
But its still not working on my machine any other check which needs to be done.
- v-yulgu-msft
  Microsoft Employee
  8 years ago
  Hi vishalc,
  
  Can you refresh dataset manually on desktop successfully?
  
  Regards,
  
  Yuliana Gu
  - vishalc
    Frequent Visitor
    8 years ago
    Hi
    
    Yes i can refresh dataset manually on Desktop.
gourangib
Frequent Visitor
8 years ago
Hi,
Even I am facing the same issue. My gateway is online and its able to connect to SSAS cube successfully. Even from power bi desktop, dashboard shows data but after publising to report server it shows error.

Please help somebody.

Regards,
Gourangi
- vishalc
  Frequent Visitor
  8 years ago
  Hi Gaurangi
  
  Any luck with the issue
  - gourangib
    Frequent Visitor
    8 years ago
    No