Azure Databricks refresh works locally but suddenly stopped working in Power BI Service

[GSE]

Hi all,

my dataset is connected to Azure Databricks (no other source) and I used to be able to refresh the dataset locally and via scheduled refresh in Power BI service. As of last week Friday, I am getting the following error in Power BI service and in Power BI desktop:

A colleague of mine is able to refresh the dataset locally, so I assumed it had to do with my Azure databricks access rights which might have actually changed due to internal processes. Therefore the colleague took over the dataset in Power BI service, entered his access details and set up an automatic refresh. However, he is now also getting the same error in Power BI service. He can refresh locally, but not in Power BI service.

Can anyone help?

Thanks and best regards

GSE

[v-xiaotang]

Hi @GSE 

Please check if this post can help,

https://community.powerbi.com/t5/Service/Refresh-Failed-Internal-Service-Error/m-p/381780

if this still doesn't solve your problem, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[GSE]

Hi @v-xiaotang,

unfortunately, it still doesn't work. I can update all tables locally except for one. If I update this table by itself, or update the entire dataset I get the mentioned error on the one table which I cannot update manually. 

Any idea?

Best regards

GSE