Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Azure Data Lake Storage Gen1 fails to refresh when published to web.

We are using the Azure Data Lake Storage Gen1 connector to connect to adl://oursubscription.azuredatalakestore.net/. Refreshing the report on powerBI desktop works fine, but when it's published to the web the scheduled refresh fails. We have added our AAD credentials to the scheduled refresh but still hit:
Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Message: Unable to connect to the remote server Table: *TableName*.
Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID: 93c55c6f-52f3-4698-8471-4188acd4712b
Request ID: 607f3aad-ccc1-c460-b60c-1ee1ceffab13
Time: 2019-11-21 18:06:06Z

Status: New
Comments
v-yuta-msft
Community Support

@chrile ,

 

I would suggest you create a support ticket here.

 

Regards,

Jimmy Tao

yuhl
Microsoft Employee

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?