Forum Discussion

daniele_tiles's avatar
daniele_tiles
Icon for Advocate II rankAdvocate II
5 years ago

Power BI, Dataset and oAuth

Hi to all, I've a question about the usage of oAuth for resource on Power BI. We've got some cases (Power BI reports based on files on Teams, or Power BI reports based on data on Synapse) that we ne...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi daniele_tiles ,

You are right. If the password of the account used to configure the data source credentials is changed, the datasource credentials need to be updated. If the password of another account is changed, it has no effect on the datasource credentials, and not need to update the credentials.

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

daniele_tiles's avatar
daniele_tiles
Icon for Advocate II rankAdvocate II
5 years ago

Hi Winniz,

wait, I didn't understand your message.

Today I've got this dataset with oAuth:

 


My password changes every 90 days, but I don't have to update in Power BI Service, for each dataset, my credentials every 90 days...am I right?

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi daniele_tiles ,

     

    As shown in the figure below, if I use the admin account to configure the dataset credentials, only when the admin password is changed, the dataset credentials need to be updated. But if the password of another account is changed, there is no need to update the credentials of the dataset.

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi @daniele_tiles , @v-kkf-msft  , this post was usefull for one of my case too!

      Just to extend and understand more!

      When we use Oauth authentication and go to Edit credentials, it asks for Pickup an account, so if we pickup "Service user account" and save the connectin does that mean, while users use this connection serviceaccount credentials used for data refresh or my credentials used for data refresh?

      Can you please provide info on same if possible

      • v-kkf-msft's avatar
        v-kkf-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ，

         

        With OAuth2 authentication, whichever user refreshes the data will be authenticated using the account ("Service user account") that you are editing credentials.

         

        Best Regards,
        Winniz