cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DavidJLitttle Frequent Visitor
Frequent Visitor

PowerBI Pass-through Authentication for Data source

I have a scenario that may be just me misunderstanding something ...

 

If i create a report in PowerBI Desktop, and use OData sources using my Organisational (O365 AD) account ..

I then uplaod that report to the PowerBI Service

(Am I currect in believeing at this point, the data is static, as to whetever i last refreshed it with?)

I then set it to Scheduled refresh and to use a gateway .. i have to specify data source credentials on the pBI service here .. BUT what if i want the credentials (and hence the permissions) of the user viewing the report to be used to access the data ? How can this be done on a gateway ?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: PowerBI Pass-through Authentication for Data source

@DavidJLitttle Yes, it is static when you use "import" (default) connection method. Typically you filter and manage what people see using Row Level Security in the Power BI Model. There are only a few connections (live connection to Analysis Services) and (I believe Azure SQL via direct query) that allow passing end user creds. I'd recommend looking into RLS.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

1 REPLY 1
Super User III
Super User III

Re: PowerBI Pass-through Authentication for Data source

@DavidJLitttle Yes, it is static when you use "import" (default) connection method. Typically you filter and manage what people see using Row Level Security in the Power BI Model. There are only a few connections (live connection to Analysis Services) and (I believe Azure SQL via direct query) that allow passing end user creds. I'd recommend looking into RLS.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors