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 translate. Because of the type of data we have, we're actually legally obliged to NOT use cloud services, and even if we weren't, I'd want to avoid it. I would also like the authentication to be just to the server - and once you're in, authentication to the individual databases and datasets is 'hard coded' within the reports (ie. not having to create 150+ SQL accounts for each user). I've seen posts of people complaining about having a login, but again, these are all Azure-based, and don't seem to be relevant to a local BI report server. Thanks in advance for any advice/directions.