Forum Discussion

schoden's avatar
schoden
Post Partisan
3 years ago
Solved

service account for cloud based Datasource needed ?

Hi All,    To connect Azure SQL Database which is cloud based to power BI , we do not need gateway for refresh , how ever do we need Service account for Dataset schedule refresh or not ?     Can ...
Need Help
Show and Tell
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, schoden 

    Any developer including you can be the dataset owner.And you can also use "take over" feature in the setting of the dataset to be the dataset owner after he/she exits the company .

    For more information, you can refer to :

    How to Change the Dataset Owner - Microsoft Power BI Community

    If you want to use a service account to be a owner then that service account should also have Power BI Pro license.

    For more information, you can refer to :
    Dataset permissions - Power BI | Microsoft Learn

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi, schoden 

Any developer including you can be the dataset owner.And you can also use "take over" feature in the setting of the dataset to be the dataset owner after he/she exits the company .

For more information, you can refer to :

How to Change the Dataset Owner - Microsoft Power BI Community

If you want to use a service account to be a owner then that service account should also have Power BI Pro license.

For more information, you can refer to :
Dataset permissions - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

 

 

cheryl-lee33's avatar
cheryl-lee33
Helper I
3 years ago

Hi,

Can you please explain more about using or creating a service account for Power BI?  We have created so many Power BI reports and there are so many datasets to take over when someone left.  Service account is the right idea to proceed.  Yet, how do I find out the license required for a Power BI service account?  How's the license cost different from the individual account?

 

There seems to be some posts about using API to assign datasets to a "group".  Any thoughts?