Forum Discussion

mamasek's avatar
mamasek
New Member
6 years ago

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 dat...
Azure Data Lake Store
Refresh
yuhl's avatar
yuhl
Microsoft Employee
6 years ago

Same here. Guys, I have .tsv file from Cosmos too, and connect it with PBI via Azure data lake Gen1.

suddenly, all refresh just got 

Unable to connect to the remote server Table: Query1.
 
 
 
 
But local refresh works. I guess this is a transient server side issue of PBI or azure data lake. Could you pls let me know what's going on?
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Our team is having the same issue, 

     

    However we are using sharepoint as our host for the reports with the data coming from MS Azure Data lake.

    However every time we try to push a manual refresh or a scheduled refresh in the service we get the same error message: 

     

    Unable to connect to the remote server Table - "Table Name changes each time". 

    However i am able to refresh the dataset in desktop. 

     

    I have already cleared the Cache and deleted and reinstated all permissions as well so cannot think what else could be the issue. 

     

    Any help would be much appeicated.