Forum Discussion

VermontSC's avatar
VermontSC
Frequent Visitor
8 years ago

AD authenticaion on local Power BI server (with SQL 2017)

Hi, I'm trying to find how to set up authentication to a local PowerBI report server (allow those in an AD group).  It seems all the documentation is focussed on running via Azure and doesn't transl...
Active Directory
AD
authentication
local
Report Server
VermontSC's avatar
VermontSC
Frequent Visitor
8 years ago

Hi v-qiuyu-msft,

You post tells me it *can* be done, but not *how*.  Note that it's not just allowing access, it's also blocking access for those who should not have access... as stated in my original post, only memebers of a certain AD group can do so.

 

I am already running a local BI server (as part of SQL Enterprise), and I can configure access to the reports as mentioned in your like, but I cannot find out how to force authentication to the BI server, and therefore allow and block groups of users (or 'public') from the server itself.

 

Ideally, I'd be able to have different groups access different PBIX, but I'll take yes/no access to the BI server.

 

Regards,

MaxSukholovyy's avatar
MaxSukholovyy
Frequent Visitor
8 years ago

Hi VermontSC, I have the same scenario here...Did you solve it?

  • VermontSC's avatar
    VermontSC
    Frequent Visitor
    8 years ago

    Hi,

    I've actually been tied up with other projects. I haven't tried the security info in the post above, so that may work. From memory, it's a "handball to your DBA" type solution (though I'm also my DBA).