Unable to connect to the remote server Table: Query1. But local refresh works.
Hi, we have a .tsv file in Cosmos and script which uploads the data to azure data lake. I have a simple dashboard which connects to the data lake and it works fine in PowerBI Desktop (I see the data and refresh works). However, when I upload it to our PowerBI app, the refresh (manual or scheduled) always fails with a message: Unable to connect to the remote server Table: Query1. Does anyone know how to debug this issue? Everything worked fine few days ago and suddenly none of the reports usingGateway setting for Azure Data Lake Store
I'm using Azure Data Lake Store as data source, and now need to connect it in gateway. How should I set it? I though it should be ODBC, but failed as below. Is the type wrong or anything else wrong? (BTW, I tried Authentication method "Basic" and "Windows", both failed with same details).
