Forum Discussion

lg01's avatar
lg01
Advocate III
2 years ago
Solved

Error "Microsoft SQL: Integrated Security not supported."

We are experimenting with Datamarts in Power Bi. I created a workspace, then inside this Workspace I created a Datamart as an administrator. I then loaded some data into the Datamart and was able to ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi lg01 ,

    If I understand correctly, the issue is that you had the error when the user connected to the SQL point of the Datamart. Please try the following methods and check if they can solve your problem:

    1.Ensure that the user is using Azure Active Directory authentication to connect.

     

    2.Windows authentication is not supported.

     

    3.Check if the suer has the necessary permissions to access the SQL Server.

     

    Best Regards,

    Wisdom Wu

  • lg01's avatar
    lg01
    2 years ago

    I ended up opening a ticket with MS support. They suggested upgrading the Desktop Application to the release of January 2024. We did a test and worked 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi lg01 ,

If I understand correctly, the issue is that you had the error when the user connected to the SQL point of the Datamart. Please try the following methods and check if they can solve your problem:

1.Ensure that the user is using Azure Active Directory authentication to connect.

 

2.Windows authentication is not supported.

 

3.Check if the suer has the necessary permissions to access the SQL Server.

 

Best Regards,

Wisdom Wu

karthikkeyank's avatar
karthikkeyank
Advocate I
1 year ago

Goto data source settings from options and Edit permission --> Choose Microsoft Account --> Enter credentials --> Hit refresh. It should work

 

Thanks
Karthik