Forum Discussion

TP129's avatar
TP129
Frequent Visitor
4 years ago

Where to find data source credentials?

Hi everyone, 

I was trying to set up a scheduled refresh on Power BI Service but this is what I encountered

I used my login credentials for Snowflake once when I first imported the data to Power BI Desktop and I had been able to use it since then. However, now that I'm done with my report, I've published it to Power BI Service and need to have a scheduled refresh. When I tried putting my user credentials again, this was the error message. 

I assume that I should be able to get this information from Snowflake because this is where I got my data from, but I don't know where exactly I should look for it. I've also asked my manager in case I got limited access to the system but he had no idea either. Could anyone please show me how to get the information? 

Need Help

5 Replies

  • HarishKM's avatar
    HarishKM
    Super User
    4 years ago

    TP129 You can open Power bi file and then Go to transfrom data and under that select datasource credential then update or edit credential in that tab .Refer below image.

     

     

    • TP129's avatar
      TP129
      Frequent Visitor
      4 years ago

      HarishKM I did as you suggested and published the report to PBI Service again but still get the same error. Right now I only have my Snowflake login credentials. I guess my question is can I use my current credentials for PBI Service or do I need other credentials (something that is used specifically for the data source)? If I need a different one for data source then where can I find it?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hey were you able to find a solution for this creditials issue? 

         

  • jeffshieldsdev's avatar
    jeffshieldsdev
    Solution Sage
    4 years ago

    Sorry to ask, but you used Basic authentication in Power BI Desktop too?  My org uses SSO, so that's why I ask.

    • TP129's avatar
      TP129
      Frequent Visitor
      4 years ago

      jeffshieldsdev in my PBI Desktop it's automatically set as Basic. I'm not sure, was that why I got the error? In PBI Service I see 2 options: Basic and OAuth2. I've tried both but none of them works.