cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jatneerjat Member
Member

Data source credential in power bi service

Hi,

 

What is the below checkbox represents.What is OAuth2 credentials?

Should i check it or not?

 

7.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Data source credential in power bi service

OK, then you do not need to worry about that checkbox and should leave it unchecked. That checkbox really only applies to connecting to the data source through Direct Query and doesn't apply to import mode.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


6 REPLIES 6
Super User
Super User

Re: Data source credential in power bi service

OAuth is an open standard for token-based authentication and authorization on the Internet. This is what you use connecting to Office 365 for example. Basically, what this is saying is that each user will authenticate as themselves versus the credentials that you are entering being stored in the data source connection (everyone uses those credentials). 

 

What type of data source are you connecting to?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


jatneerjat Member
Member

Re: Data source credential in power bi service

Hi @Greg_Deckler,

 

Thanks for your response!

I am connecting to Azure sql database.So I have to check it or not?

 

Super User
Super User

Re: Data source credential in power bi service

The central question that needs to be answered regarding that is, are you planning to distribute this and have people see different information based upon their permissions to the source data? In other words, should people all see the same thing or should they see information solely based on their permissions within the database? And are you connecting via Direct Query?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


jatneerjat Member
Member

Re: Data source credential in power bi service

Hi @Greg_Deckler,

 

I have implemented row level security so people see different information based upon their permissions to the source data.Every individual will see their own data.

I am connecting through the import option and not through direct query.

 

 

Super User
Super User

Re: Data source credential in power bi service

OK, then you do not need to worry about that checkbox and should leave it unchecked. That checkbox really only applies to connecting to the data source through Direct Query and doesn't apply to import mode.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


jatneerjat Member
Member

Re: Data source credential in power bi service

Thanks alot @Greg_Deckler for the detailed explanation.