Online Data Source - Analysis Services - Gateway Setup/Connection Issue

[dstramilov]

Hello,

I am getting during gateway setup for my Analysis Services data source.

"Unable to connect: We encountered an error while trying to connect to https://betaexcel.vivonet.com/excel/. Details: "Username needs to include a domain. Please use the format user@domain or domain\user and try again."Show details

Troubleshoot connection problems"

Previously, I was able to create report in powerbi desktop then publish & schedule refresh, now power bi requires go thru gateway creation for online data source. 

[edejes2]

Hello dstramilov, 

Here is a link https://www.youtube.com/watch?v=Y9Dc7jd5VaI to a video that may help you with that issue. will be a lot of writing to go thru detail explanation. Please let me know if that help or not. I can help you troubleshoot that in case that you don't get it to work. 

Regards!

Erich Dejesus

[dstramilov]

Thank you for your response.

This video talks about on-premise data source, but in my case I am using online data source (Analysis Services Cube). 

[dstramilov]

Any other ideas on this issue?