Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
FilipVDR
Helper I
Helper I

How to set up different Data connections

At our organisation we already use a SQL server database with different scheme's, which is accessed by our SAS environment.

Within our SQL database we have already created different users like (Finance_01, Finance_02).

Within SAS we have grouped users X01, X02, X03 in a group which has the right to use user Finance_01.

 

Is something similar possible within PowerBI Desktop? Or do they need their account X01 on the database?

1 REPLY 1
ribisht17
Super User
Super User

@FilipVDR 

 

You can get security groups created in Active Directory you can use those instead of individual users. This actually works well in many organizations as people raise a help desk ticket requesting access to specific report areas and our help desk people just have to add them to an AD group,

 

Power BI Security - Power BI | Microsoft Docs

 

Regards,

Ritesh

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.