Forum Discussion
Datasource Creation Failure: Attempting to Connect to a SSAS Running on Azure VM
I've really tried everything I believe I can find... but instead of saying what I did do and confuse anything. Here is the error,
Unable to connect: We encountered an error while trying to connect to crmolap.cloudapp.net. Details: "The connection to the Analysis Services instance timed our or was lost. Ensure that the server and the 'SQL Browser' service are running
- Azure VM Sql 2016
- Ports for 1434, 1433, 2382, 2383 (TCP / UDP) are opened
- I can connect from the local VM to SSAS
- I have the Power BI Gateway installed (and it says good). I can see it from WWW.PowerBI.Com
However I get the error about being unable to connect :-( and I can't figure out what to do. My Guess is it is a Firewall / Port type issue (as I can make it work from my local machine)
Maybe it's the whole random port for SSAS.. or something else :-( just not able to put things together in my own brain to make it work.
Any suggestions would be awesome and thank you
What I figured out (and NO i don't know why this is so, just that it is), is that i had to use the IP address, instead of the Virtual Machine DNS Name.
I validated this by opening SMO for Analysis Services... (and btw I was ON the vm when doing this). Typed in the DNS name and it would fail with the errors above (server not running etc).
I said what the heck. I pinged that DNS name and it appeared to have the correct IP address, but i said ok.. let me just try the IP address. And bingo it worked
Went back into Power BI, typed in the IP and it worked..
that's dumb.
1 Reply
What I figured out (and NO i don't know why this is so, just that it is), is that i had to use the IP address, instead of the Virtual Machine DNS Name.
I validated this by opening SMO for Analysis Services... (and btw I was ON the vm when doing this). Typed in the DNS name and it would fail with the errors above (server not running etc).
I said what the heck. I pinged that DNS name and it appeared to have the correct IP address, but i said ok.. let me just try the IP address. And bingo it worked
Went back into Power BI, typed in the IP and it worked..
that's dumb.