Teams CQD PowerBI - Data Source Credentials

Occasional Contributor

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

1 Reply
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