Dataset credentials update goes into infinite loading

[kevalkakadiya]

I had made a report in Power BI desktop with db2 data source and published on Power BI Server.

When i tried to refresh the data in the report or schedule auto refresh for the related dataset, it asks me to re configure the credentials for all the data sources. When i enter valid credentials and click on sign in, the loader goes on spinning indefinitely. Please help.

[vanessafvg · Accepted solution]

is this an on prem database?  if so it will need a on premise gateway installed to access the data.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

[vanessafvg · Accepted solution]

is this an on prem database?  if so it will need a on premise gateway installed to access the data.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

[kevalkakadiya · Accepted solution]

so gateway is mandatory to access data if you publish you app on power bi service?

[vanessafvg]

if the data is sitting on prem yes.  It is not always needed for cloud.