Connection to Fabric SQL Endpoint

KNIME Analytics Platform
1

I’ve seen the topic " Connector to Fabric SQL Endpoint" because I have the same problem, but there isn’t a solution in this post.

I’ve configured the authentication Microsoft node with Interactive type and Power BI scope. The execution works ok.

The next node is Microsoft SQL Server Connector with driver for Microsoft SQL Server v9.4.0 and the host name *******.datawarehouse.fabric.microsoft.com

When I run the second node, I have this error message: Execute failed: Could not login because the authentication failed. ClientConnectionId:caab9de9-8ece-4c70-afe1-9375bac27b32

Can anyone help me?

2

Hello @CristianM ,

welcome to the KNIME community :slight_smile:

The settings of the Microsoft SQL Server Connector node sound correct.

However you need to change the scope in the Microsoft Authenticator node from PowerBI to Azure SQL Database as shown below:

image
image616×868 20.5 KB

Bye
Tobias

1 Like
3

Thanks for your reply @tobias.koetter .

I’ve changed the authentication mode but I need to know exactly this permisions to manage it:

image
image395×503 16.8 KB