Forum Discussion
Which credentials are used when using direct query
Hi FabScone75
If you can, let us know which data source you are connecting to so that we can validate. If you can use Single Sign On, which will then pass the user's credentials through to your Directquery data source.
Hello GilbertQ , the source is Starburst. Thank you.
Hi FabScone75 ,
Thanks for confirming the source as Starburst.
As already explained by cengizhanarslan , GilbertQ and Murtaza_Ghafoor , DirectQuery in the Power BI Service uses the stored connection credentials unless Single Sign On is supported and configured.
After validating against the official Power BI SSO documentation, Starburst is not currently listed as a supported data source for SSO in Power BI Service:
Overview of single sign-on for on-premises data gateways - Power BI | Microsoft LearnThere is also an existing Power BI Ideas request requesting Azure AD based SSO support for the Starburst connector, which confirms that this capability is not available today.
SSO for Starburst connector in Power BI Service (A... - Microsoft Fabric Community
As a result:
->Power BI cannot delegate the report viewer identity to Starburst
->DirectQuery executes using the configured connection credentials
->Starburst user specific security is not applied per report viewer
Given the current limitations, enforcing security using RLS or OLS within Power BI is the supported approach.
If this functionality is important for your scenario, you may want to vote for the existing Power BI Ideas request to help prioritize support for Starburst SSO in the future.
Thank you.
Hi FabScone75 ,
Just checking in to see if the response helped clarify the behavior and current limitations around SSO with Starburst.
If this capability is important for your scenario, please consider voting on the existing Power BI Ideas request.Let us know if you need any further clarification.
Thank you.
