topic Report Server and Power BI connection as current user... in Report Server

Report Server and Power BI connection as current user...

rgiltner — Fri, 22 Apr 2022 12:36:25 GMT

Trying to get a handle on what types of connections can utilize Windows Authentication as the user viewing the report, and which cannot.

I was hoping a great deal of connection types would allow this, but it seems to be only available for SQL Data connections utilizing DirectQuery.

While a paginated report data source can utilize the current user for all of its connection types (SQL, SharePoint List, SSAS, ODBC, etc.) it doens't appear a Power BI dataSource can. I had hoped to be able to use DirectQuery to a SharePoint list, and use the current users windows credentials to connection, thereby moving permissions checks to the SharePoint side.

Am I just missing something ?

Thanks.

Re: Report Server and Power BI connection as current user...

v-luwang-msft — Mon, 25 Apr 2022 06:51:21 GMT

Hi rgiltner ,

According to the official article, sharepoint list does not support direct query mode.

And you could refer the following article:

SharePoint Online List Direct Query method

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

Re: Report Server and Power BI connection as current user...

rgiltner — Mon, 25 Apr 2022 20:54:57 GMT

Thanks Lucien. So does Power BI Report Server only utilize Windows Auth as the current user on "DirectQuery" type data connections only ? And only those can that be implemented ?

Re: Report Server and Power BI connection as current user...

v-luwang-msft — Tue, 26 Apr 2022 02:15:05 GMT

Hi rgiltner ,

Refer the article,In my opinion, the following are basically supported.

And refer:

https://docs.microsoft.com/en-us/azure/active-directory/manage-apps/what-is-single-sign-on

https://docs.microsoft.com/en-us/windows-server/security/windows-authentication/windows-authentication-overview

https://community.powerbi.com/t5/Report-Server/Report-server-direct-query-with-windows-authentication-gets-SSAS/m-p/2023305

Best Regards

Lucien