'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Enable SSO in Power BI Apps with Azure Data Explorer DirectQuery
Question details
The user needs to enable Single Sign-On (SSO) for a Power BI report using Azure Data Explorer via DirectQuery after publishing it to the Power BI service.
- Product
- Power BI / Azure Data Explorer
- Device & OS
- not provided
- Scenario
- Publishing a Power BI Desktop report to the Power BI service where app viewers must access data using their own Power BI identities and permissions.
- Observed behavior
- The data connection works locally in Power BI Desktop, but the Single Sign-On (SSO) option is missing or not exposed once published to the Power BI service.
Ensure you have administrative or owner permissions for both the Power BI workspace and the Azure Data Explorer cluster before attempting to modify Single Sign-On or DirectQuery credential settings.
Seek Official Azure Data Explorer Support for SSO Configuration
Since specific DirectQuery and SSO integrations involve complex tenant-level settings, contacting Microsoft Azure support is the most effective approach.
Microsoft engineers possess the required product expertise and diagnostic tools to confirm whether your specific scenario and SSO configuration are supported by the current Power BI infrastructure.
Open your web browser and go to the official Microsoft Azure Data Explorer Q&A community page.
Create a new post detailing your Power BI Desktop version, Azure Data Explorer setup, and the specific DirectQuery behavior observed after publishing.
Ask Microsoft support engineers to verify your tenant configuration and determine if there are backend limitations preventing the SSO option from appearing.
Verify Power BI Dataset Data Source Credentials
Check if the published dataset's settings in the Power BI Service allow you to edit the data source credentials to enable SSO.
Try WPS Office for Comprehensive Data Analysis and Reporting
While advanced Azure DirectQuery setups require Microsoft's specific ecosystem, WPS Office provides a lightweight, highly compatible alternative for everyday data analysis. WPS Spreadsheet handles complex datasets, pivot tables, and visualizations with ease, making it perfect for users who need a fast, free, and robust data management solution.
- 1. Download and Install: Visit the official WPS website to download the free installation package and follow the prompts to install it on your device.
- 2. Open WPS Spreadsheet: Launch WPS Office and open WPS Spreadsheet to start a new data analysis project.
- 3. Import Your Data: Easily import your existing Excel files, CSVs, or text data to leverage advanced charting and pivot table features.
Frequently Asked Questions
Why is the SSO option missing for my dataset in Power BI Service?
The SSO option might be missing if the underlying data source does not natively support Azure AD-based Single Sign-On through the standard cloud connection, or if the initial DirectQuery connection in Power BI Desktop was not configured using the correct Organizational account credentials.
Can I use SSO with Azure Data Explorer via an On-premises Data Gateway?
Typically, cloud-to-cloud connections like Power BI to Azure Data Explorer do not require an On-premises Data Gateway. Ensure your connection in the Power BI service is configured directly as a cloud data source.
What permissions do report viewers need when SSO is enabled?
When SSO is enabled via DirectQuery, every viewer accessing the Power BI app must have explicit read permissions granted directly within the Azure Data Explorer database in addition to having access to the Power BI app itself.
How do I check if my Power BI Desktop report is using DirectQuery?
Open your report in Power BI Desktop and look at the bottom right corner of the application window. It will indicate the current storage mode as either 'DirectQuery', 'Import', or 'Mixed'.
