Published dashboard problem

Swethat99 · ‎03-21-2022

Hello!
I have a problem with a dashboard when I publish it to Power BI Service. In Power BI Desktop dashboards works just fine. The data source of my dashboard is SQL query, but I don't use gateway and just publish dashboards without refreshing them in PBI Service.
So the error that I get is: "This data source /data base name/ is missing credentials. Add the data source credentials by using the dataset settings page .This data source {0} is missing credentials. Add the data source credentials by using the {1}.".

Also, I have a few other dashoarbds, that have the same queries, but with different filters and they works without problems.

Faabry · ‎02-20-2023

Hi, I'm new at Power BI, I just did a dashboard on Power BI desktop and tried to publish it, but when I try to acess it on "app.PowerBI" there's an error saying to me to try later or contact the support, I'm trying to solve this problem during almost 2 days
please give me a feedback

ibarrau · ‎03-21-2022

Hi. Considering you have a SQL databse without gateway. If this configured one time and then the source change credentials, host or something, it might ask again.

If you go to Dataset Settings or Dataset Schedule Refresh, you will found a section "Data Source Credentials". Edit those with the correct credentials. Check out the last title on the picture, it has an "X" in a source asking to Edit Credentials. Try that on your dataset.

Gateway issue vs web