You can translate the question and the replies:

Setting up a Gateway/ODBC Data Source on a virtual machine for Power BI

Hi, I recently created a Power BI report based on a Denodo datasource and published it to powerbi.com. I want to set up a scheduled refresh on powerbi.com. In order to do that, it looks like I need to use a gateway. To ensure that the refresh is consistent, I have started to create a gateway on a virtual machine. I am running into issues when I do this. One issue in particular is when I go to create a ODBC datasource and test the connection I get this error: "SERVICE NEGOTIATION FAILED; THE CLIENT AND SERVER CANNOT COMMUNICATE, BECAUSE THEY DO NOT POSSESS A COMMON ALGORITHM IN DOSCHANNELNEGOTIATION:CREATESCHANNELCREDENTIALS" In creating the ODBC datasource, I have replicated the exact same setup I have on my local machine. The only difference is that this is on a VM. Do you have any advice for me on how I can get this to work? Overall, my ultimate goal is to have my Denodo data refresh automatically at least once a day on powerbi.com without any dependencies on my local computer. If there is another way to achieve this please do let me know. Thanks!
user
14-09-2021 11:23:26 -0400

1 Answer

Hi, Regarding your question on how Power BI service connects to Denodo source, it is suggested to use On-premises data gateway as a bridge for transferring on-premises data from Power BI Desktop into Power BI service, for details please refer to this Denodo community KB article on [Denodo Power BI Custom Connector - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Power%20BI%20Custom%20Connector%20-%20User%20Manual). The error “BECAUSE THEY DO NOT POSSESS A COMMON ALGORITHM” suggests TLS protocol does not match between client and server. When you enable SSL in Denodo only TLSv1.2 and TLSv1.3 are allowed. I would check if TLS protocols match to resolve your problem. According to Microsoft doc [Automatic page refresh in Power BI Desktop - Power BI | Microsoft Docs](https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh), Power BI Desktop can be scheduled to get refreshed automatically. And when the Power BI refresh starts, it would get the latest data from the corresponding Denodo views. If you still need help and you have a valid support user account, please open a new support case at the [Denodo Support site](https://support.denodo.com/) so that the support team can assist you. Hope this helps!
Denodo Team
16-09-2021 04:10:30 -0400
You must sign in to add an answer. If you do not have an account, you can register here