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

5 Replies

  • markwilson's avatar
    markwilson
    Frequent Visitor
    4 years ago

    I have the same problem.

    I'm connecting to a sharepoint online library and a SQL Server DB as my data sources. I don't need a gateway for this.

    • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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