cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Laz Member
Member

Power BI Gateway Authentication Mode Username and Password - Best Practise

Hi Community,

 

I currently have the On-Premise Power BI Gateway up and running.

 

When i go to the 'Manage Gateways' and select a Data Source, whether it is a folder, SQL DB, Oracle DB, File, etc. i must enter my username and password.

 

However, as we set up password to be reset every 30 days, this can be very troublesome and introduces a risk if unable to enter updated passwords to the Data Sources after they expire. This can result in Dashboards and Reports to being refreshed!

 

The initial idea was to create a single user who has access to all Data Sources and the password never expired. However, as you can imagine this has been questioned for security reasons. Before i start exploring all options, i through to see what other PBI enthusiasts have done in this scenario.

 

Thanks All,

 

Laz

 

5 REPLIES 5
v-danhe-msft Super Contributor
Super Contributor

Re: Power BI Gateway Authentication Mode Username and Password - Best Practise

Hi @Laz,

Based on my research, I am afraid you could not achieve this feature currently, this is decided by your database, different database may different ways of identifying, you may submit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Laz Member
Member

Re: Power BI Gateway Authentication Mode Username and Password - Best Practise

Hi Daniel,

 

Thank you for the reply! I dont think a feature is the solution here.

 

The challenge is using my own username credentials as a connection to the data source, introduces a level of risk, as my password may expire and Power BI will not be able to refresh the data.

 

I undertand that this is not a Power BI issue or a feature that is needed. Instead what i am asking for is how other people overcome this challenge?

 

Would it be best to:

- Create a single user with access to all data sources and password never expires

- Create a single user for each source and password never expires

- Etc.

 

 

Thanks,

Laz

v-danhe-msft Super Contributor
Super Contributor

Re: Power BI Gateway Authentication Mode Username and Password - Best Practise

Hi @Laz,

As far as I am concerned, I would prefer to choose create a single user for each source and password never expires. Hope it could help you.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Laz Member
Member

Re: Power BI Gateway Authentication Mode Username and Password - Best Practise

Thanks for the reply @v-danhe-msft

v-danhe-msft Super Contributor
Super Contributor

Re: Power BI Gateway Authentication Mode Username and Password - Best Practise

Hi @Laz,

If your problem could be solved, don't forget to mark a reply as answer to close this topic.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 504 members 4,004 guests
Please welcome our newest community members: