PowerBI service account

Hello Everyone,
In my company, I have been trying very hard with my IT team to get the SSO working in PowerBI service gateway setup but so far we haven’t been able to get that working so we are planning to get a Service account created which I can then use to login into gateway and start running the daily schedule refresh.
From my understanding, the service account would need PowerBI Admin role and access to all the SQL databases( i am importing data from SQL server). Is there anything else which is needed to get the service account setup?

Many Thanks!

Hi @kuberkgupta - Your Service account will need access to Gateway and all SQL Sources. Also, all SQL Databases shall be accessible from machine where Gateway is installed.

Power BI Admin Role is not required for schedule refreshes.

Thanks
Ankit J

1 Like

Hi @kuberkgupta, did the response provided by @ankit did the response provided by @ help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

thanks @ankit !