PowerBI Service Data Refresh Issue - Azure Databricks

[syasmeeen]

Hi,

I developed a report with 2 datasources Azure datbricks and Sharepoint in Production Premium workspace. My report was refreshing fine without any issue until I had to change my windows password (Organization's protocol). After I changed the password my Azure databricks connection is not refreshed in the PowerBI service. I am able to connect and query the databricks without any issue. Suprisingly Iam able to refresh the same report in desktop version but the problem is with the refresh on PowerBI service. 

I tried signing in different browsers with OAuth, Basic and AccountKey but nothing worked. I tired updating the credentials in desktop version and published it agian but still no use. 

I am blocked with data refreshs on a production report which is very critical. Please help mw with this. 

Here are the images with the connection error.

[v-yetao1-msft]

Hi @syasmeeen 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regard

Community Support Team _ Ailsa Tao

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

[v-yetao1-msft]

Hi @syasmeeen 

You need update your credentials in Manage gateways .

In order to ensure that the Service and the data source can be connected, we need to configure the data source on the Service, and we need to enter credentials during this process. So when you update your Windows password, you need to configure the data source to update credentials.

Best Regard

Community Support Team _ Ailsa Tao

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

[Shahfaisal]

You will need to updtae the credentials in Power BI Service (in the gateway)