Get data from Microsoft Fabric one lake delta table

Integrator.io
1

How can I get data from Microsoft Fabric one lake delta table? Is there any method? I tried several API's but could not figure out how to get data rows, not the table names and meta data.

I tried also SQL endpoint, but it needs "Active Directory" authentication method, not username and password.

Any ideas?

2

The "Active Directory" requirement you're seeing is correct — Fabric only accepts Microsoft Entra ID authentication on the SQL endpoint, not traditional username/password. The way to handle this is to register a Service Principal in Microsoft Entra ID and use it from Celigo.

Full setup steps including the Entra ID app registration, granting database access and iClient configuration in Celigo are documented here: :backhand_index_pointing_right: Set up a connection to Microsoft SQL

3

I created credentials according to the instruction, but I am encounding this error:

image
image1475×462 40.3 KB

I tried same credentials in SQL management studio and it works, so this should not be permission errors:

image
image541×584 23.1 KB

4

Looks like this requires some troubleshooting assistance. Could you log a support case for this ?