Forum Discussion

Dale_LTU's avatar
Dale_LTU
Copper Contributor
Oct 28, 2022

Teams CQD PowerBI - Data Source Credentials

I've had PowerBI reports setup and shared with relevant interested parties via a Teams Channel for a while.

To date I've just used my own account for the Data Source Credentials - but this isn't ideal, when my account Password expires, I have to remember to go change the password for the Dataset in PowerBI.

Ideally, I'd like to setup a service account that's just used to refresh the data in these reports - what is the minimum access I need to give such an account - will giving it Reports Reader Admin role be enough to refresh the PowerBi datasets?

Thanks

analytics
best practices
microsoft teams

1 Reply

Sort By
  • StefanFried's avatar
    StefanFried
    Steel Contributor
    Nov 06, 2022
    Reports Reader would work although you would not be able to see end-user information. Keep in mind that the reports reader role would give you access to other report data from your tenant.
    in my opinion i would use a teams communications suport role for this purpose.
    hope this helps
    stefan

Resources