Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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
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
Best Regards
Lucien
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
Best Regards
Lucien
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 ?
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
16 | |
16 | |
3 | |
2 | |
2 |