cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ybog Frequent Visitor
Frequent Visitor

Error: Alternate credentials for Windows authentication is not supported in DirectQuery mode

I have a big problem when i want to use DirectQuery. I have a DomainController with installed SQL Server. I have installed Data Gateway and must modify the Service Account to Local System to be able to finish setup. i have setup the Data Gateway successfully in Enterprise Mode. In PowerBi.com everything looks fine and can see the Gateway and no errors.

 

When i now create a new File with a SQL connection and Mode "Import" and publish it to PowerBi.com, then it works fine and when i schedule a refresh, this works fine, too.

 

But i want to use DirectQuery on a Database table for example. For this scenario i have created a new Power BI File and selected the same database which i already created as DataSet in PowerBI.com under my Gateway. Then i load the data in the file and while trying to load it i am always receiving the following error message:

 

Create Connections

Alternate credentials for Windows authentication is not supported in DirectQuery mode. Use your current windows credentials, supply a database credential or switch to import mode.

 

In PowerBI.com under Gateways and Data source i have used Windows Authentication and used the Administrator account which has also permission on the Database. I dont know what this message means and i should change. Can someone help me?

 

Best regards

Ybog

3 REPLIES 3
maddy Member
Member

Re: Error: Alternate credentials for Windows authentication is not supported in DirectQuery mode

Hi Ybog,

 

Were you able solve this issue?

I am getting the same error when i am tryng to use laternate credntials for windows authentication.

 

Regards ,

Maddy

AnotherUsername Frequent Visitor
Frequent Visitor

Re: Error: Alternate credentials for Windows authentication is not supported in DirectQuery mode

Any new info on this? I also have a user who has this issue

maddy Member
Member

Re: Error: Alternate credentials for Windows authentication is not supported in DirectQuery mode

Hi,

 

I had the same issue.

 

Please refer below thread for the solution.

 

http://community.powerbi.com/t5/Desktop/Direct-Query-On-SQL-Server-on-Windows-Authentication/m-p/323...

 

Regards,

Maddy

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 245 members 2,881 guests
Please welcome our newest community members: