Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

The Data Source Credentials are not accessible.

Hi Experts,   I am not able to access the Data Source Credentials in Power BI Service, Because of this I am not able to schedule the refresh. Anyone, Please help!
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    lbendlin markwilson 
    Thanks for your prompt inputs, much appreciated! I managed to resolve my issue by setting privacy level to the organisation since I was already provided a valid login.

     

    Thank you,

    Regards,

    Puru

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Burningsuit lbendlin Anand24 

can any one of you help me to address the above query?

 

Thank you,

 

markwilson's avatar
markwilson
Frequent Visitor
4 years ago

Purushothaman, I fixed the problem on my end. What I did was go into my power BI report, and from there into the Power Query Editor.

Then the Data Source Settings showed that there was a rogue data source in there.

 

Once I deleted that data source (and the tables that referenced it) I republished and the Data Source Credentials were enabled for me.

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    1. Every data source that is not directly accessible from Azure needs a gateway. That includes SQL Server.

    2. A gateway will only be selectable if all data sources from #1 have connections declared on that gateway. Connection definitions have to match exactly between Desktop and gateway.