Skip to main content

    Power BI

    New

    Separate SSO Setting for dataset when direct query to Azure SQL DB

    Vote (2) Share
    Allan Deyoung's profile image

    Allan Deyoung on 14 Oct 2021 11:48:22

    Currently, using the direct query connection to Azure SQL DB, the sso setting will impact on all datasets that use the same data source.

    For more detailed user data management, the seperate SSO setting which can impact a specific dataset will be great.

    Comments (1)
    Allan Deyoung's profile image Profile Picture

    Zuheir Ashraf Zakaria on 22 Nov 2021 02:40:40

    RE: Separate SSO Setting for dataset when direct query to Azure SQL DB

    I honestly thought the SSO Setting for the dataset was built to impact only the specific dataset until we found out later that it affects across workspace/dataset as long as it is connected to the same data source.

    Please allow the option to have it enabled dynamically only to the respective dataset. Since we are using azure data warehouse as our main source this is definitely not usable for us.