Forum Discussion

Swethat99's avatar
Swethat99
Frequent Visitor
4 years ago

Published dashboard problem

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.

Dataflow
General Comment

2 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    4 years ago

    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

    I hope that helps,

  • Faabry's avatar
    Faabry
    New Member
    3 years ago

    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