Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
TP129
Frequent Visitor

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

Screen Shot 2021-09-26 at 9.07.39 PM.png

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. 

Screen Shot 2021-09-26 at 9.08.46 PM.png

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? 

5 REPLIES 5
HarishKM
Solution Sage
Solution Sage

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

 

HarishKM_0-1632744252475.png

 

@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
Not applicable

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

 

jeffshieldsdev
Solution Sage
Solution Sage

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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.