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.