topic Re: Error "Microsoft SQL: Integrated Security not supported." in Desktop

Error "Microsoft SQL: Integrated Security not supported."

lg01 — Thu, 25 Jan 2024 15:55:14 GMT

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 connect to it from Power Bi desktop and run queries against it without any issue. I then added a user from our network to the Workspace and gave him "Member" level. This automatically gave him the rights to "Read, Write, and Reshare". When he uses the "OneLake data hub/Datamarts" connection all works well for him. However, when he tries to connect to the SQL point using the "SQL Server database" and adding a query, he gets the error "Microsoft SQL: Integrated Security not supported." We don't understand where that is coming from. Any ideas what could be happening? Do we have a permission issue?

Re: Error "Microsoft SQL: Integrated Security not supported."

Anonymous — Fri, 26 Jan 2024 01:54:13 GMT

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

Re: Error "Microsoft SQL: Integrated Security not supported."

altuntasemrah — Thu, 22 Feb 2024 08:16:42 GMT

Hello, I'm having the same problem. I haven't found a solution yet. Did you solve it? can you share?

Re: Error "Microsoft SQL: Integrated Security not supported."

lg01 — Fri, 23 Feb 2024 14:55:05 GMT

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

Re: Error "Microsoft SQL: Integrated Security not supported."

diego123cr — Mon, 22 Apr 2024 14:10:43 GMT

Same error here., it's happening on a report that was previouly working fine, and suddenly -without changes to the report- stop working. The PBI report is on the cloud and the error happened when trying to open the pbix file on the Desktop App, it's connects to a MS Fabric Datalake via Direct Query. The reports works fine on the cloud.

PBI Version: 2.128.952.0 64-bit (April 2024)

Re: Error "Microsoft SQL: Integrated Security not supported."

Anonymous — Tue, 25 Jun 2024 19:20:15 GMT

You are trying to connect to your data source using Windows authentication, rather than your MS Organizational Account.

Go to ->> Data Source Settings

Then select your Fabric/OneLake data source

Then Edit Credentials

Then change from 'Windows' to 'MS Account' and log in.

That should resolve the issue.

Re: Error "Microsoft SQL: Integrated Security not supported."

KarolinaKa — Tue, 03 Sep 2024 14:06:43 GMT

Worked, thank you!

Re: Error "Microsoft SQL: Integrated Security not supported."

karthikkeyank — Tue, 24 Sep 2024 16:26:14 GMT

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

Thanks
Karthik

Re: Error "Microsoft SQL: Integrated Security not supported."

jonathan_rosale — Mon, 07 Oct 2024 17:02:28 GMT

buenos dias,

tengo el mismo problema: Details: "Microsoft SQL: Integrated Security not supported."

antes me conectaba y todo normal ahora hasta en los reportes que ya hice no me funcionan, pero los reportes publicados siguen funcionando, ya desinstale e instale power bi desktop y no me funciona aun, quisiera saber si me podrian ayudar

topic Re: Error &quot;Microsoft SQL: Integrated Security not supported.&quot; in Desktop

Error "Microsoft SQL: Integrated Security not supported."

Re: Error "Microsoft SQL: Integrated Security not supported."

Re: Error "Microsoft SQL: Integrated Security not supported."

Re: Error "Microsoft SQL: Integrated Security not supported."

Re: Error "Microsoft SQL: Integrated Security not supported."

Re: Error "Microsoft SQL: Integrated Security not supported."

Re: Error "Microsoft SQL: Integrated Security not supported."

Re: Error "Microsoft SQL: Integrated Security not supported."

Re: Error "Microsoft SQL: Integrated Security not supported."

topic Re: Error "Microsoft SQL: Integrated Security not supported." in Desktop