Solved: Dataset credentials update goes into infinite load...

Anonymous · ‎11-07-2022

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 · ‎11-07-2022

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

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

View solution in original post

Anonymous · ‎11-07-2022

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

View solution in original post

vanessafvg · ‎11-07-2022

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

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Anonymous · ‎11-07-2022

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

vanessafvg · ‎11-07-2022

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

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!