Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

KQL Database: cannot load or query a table from Data Factory.

Hi,

 

I would like to try KQL Database within Fabric workspace to load json files for ETL metadata driven framework in Engineering experience.

 

I have created a new KQL Database in the same workspace: adf-metadata

Created new table from local file: apiIngestion

 

I wanted to read data from Data Factory using Lookup activity but got an error.:

It is weird, cause I do not manage a connection string. It is done automatically by Fabric as I use the KQL database in the same Fabric workspace.

 

datamind_0-1688717962020.png

 

 

I tried to write a table name manually but did not work.

I tried to write a query manualy but did not work.

I tried to create new KQL database with a name: adfMetadata but did not work.

 

11210: 
Failed to navigate tables from Kusto database 'eeebfcb9-d71a-4016-90fa-0f799c3a9224'. Error: Kusto Connection String Builder has some invalid or conflicting properties: Can't communicate with 'trdmtava71hzcn0eqeb18t.z6.kusto.fabric.microsoft.com' as this hostname is currently not trusted; please see https://aka.ms/kustotrustedendpoints.. ', Please consult Kusto Connection String documentation at https://docs.microsoft.com/en-us/azure/kusto/api/connection-strings/kusto Kusto Connection String Builder has some invalid or conflicting properties: Can't communicate with 'trdmtava71hzcn0eqeb18t.z6.kusto.fabric.microsoft.com' as this hostname is currently not trusted; please see https://aka.ms/kustotrustedendpoints.. ', Please consult Kusto Connection String documentation at https://docs.microsoft.com/en-us/azure/kusto/api/connection-strings/kusto

1 ACCEPTED SOLUTION
ajarora
Microsoft Employee
Microsoft Employee

This error of invalid Kusto connection string building, is identified as a bug, and is being fixed, sorry for the inconvenience.

View solution in original post

2 REPLIES 2
ajarora
Microsoft Employee
Microsoft Employee

This error of invalid Kusto connection string building, is identified as a bug, and is being fixed, sorry for the inconvenience.

Anonymous
Not applicable

Thank you, @ajarora,

Is there a way to track the issue? Perhaps through a GitHub PR or some other method?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!

JanFabricDF_carousel

Fabric Monthly Update - January 2025

Take your data replication to the next level with Fabric's latest updates!