Forum Discussion

Hoggie's avatar
Hoggie
Frequent Visitor
3 years ago

Virtual Host not working for SAP HANA DB Connection

Hi all,   We have 2 SAP HANA DB servers which allow failover should lan issue occur.  There is then one alias / Virtual Host that redirects connections to whichever DB server is running.    If i ...
Need Help
Hoggie's avatar
Hoggie
Frequent Visitor
3 years ago

Hi Aniya,  

 

Thank you for taking the time to reply. I appreciate it since i'm quite new to this area. 

 

In relation to your suggestion,  i had noted that datasoruces must match so in my testing, i found below. 

Desktop connection using Server name  / Gateway using Server Name   = Working

Desktop connection using IP address  / Gateway using IP address   = Working

Desktop connection using failiver server name  / Gateway using failiver server name   = Working

Desktop connection using Virtual Alias  / Gateway using Virtual Alias = NOT WORKING  (dispite the connection working on the desktop, the same connection on the gateway does not work. 

 

I'm waiting on further response from our central PBI platform support team but so far their response is that PowerBI does not work with virtual aliases.   This just seems bizarre.  Their solution was to create failover versions of the gateway connections so that if the DB had cause to fail over, we'd have to be notified and then manually swap over all connections to the failover connection.   This seems like a huge gap. 

 

Regs,

 

H

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi ,  Hoggie 

    Thanks for your quick response and deatiled test result ! 

    For your test results, I checked the relevant documents and descriptions, but found no information about the corresponding virtual hostname/alias. Sorry, in my working environment, there are no test conditions for SAP HANA.

     

    If you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

    It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

    The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

    For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

     

    Best Regards,

    Aniya Zhang

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