Hi, We have a Windows Server 2012R2 box up in azure running MS SQL server - I have managed to install the enterprise gateway fine and can access the SQL DB fine with PowerBI Desktop, but when I a...
This is likely due to the browser session having an out-of-date value for the gateway's public key.
Please attempt the following things:
Clear browser cache and/or try adding the datasource in another browser & validate correct date/time settings on gateway host machine.
If this does not solve the problem, please uninstall the gateway, install the gateway again and choose to 'restore' the gateway settings. (This forces key pair regeneration) After this, in a new browser session, attempt to add the datasource.
Best Regards,
Herbert