Is it possible to use an sql endpoint in fabric in Data API Builder?

[Narming1868]

Hi I'm trying to access a SQL Table in Fabric from DATA API Builder. But when I start dab with the configuration I receive the error
Azure.DataApiBuilder.Service.Exceptions.DataApiBuilderException: Cannot obtain Schema for entity TimeBookings with underlying database object source: dbo.calendardata_test_v2 due to: A server name like tcp:SERVERNAME.datawarehouse.fabric.microsoft.com,1433 is not allowed? Is my connect string wrong or does this not work.
Thanks for your help.

[Sean Leonard (seantleonard)]

is there a specific error code included with that message? Are you also connecting from DAB to DW with a managed identity?

[Narming1868]

Hi, sorry for the late answer I was out of office last week. First of all
Currently (for testing) I try to run DAB on my Local Computer so now managed identity yet. I attached the config file.
dab-config.github.json

There is no specific error code
The full exception looks like this:
fail: Azure.DataApiBuilder.Service.Startup[0]
Unable to complete runtime initialization. Refer to exception for error details.
Azure.DataApiBuilder.Service.Exceptions.DataApiBuilderException: Cannot obtain Schema for entity TimeBookings with underlying database object source: dbo.calendardata_test_v2 due to: A server name like tcp:SERVERNAME.datawarehouse.fabric.microsoft.com,1433 is not allowed
at Azure.DataApiBuilder.Core.Services.SqlMetadataProvider3.HandleOrRecordException(Exception e) in /_/src/Core/Services/MetadataProviders/SqlMetadataProvider.cs:line 100 at Azure.DataApiBuilder.Core.Services.SqlMetadataProvider3.PopulateObjectDefinitionForEntity(String entityName, Entity entity) in //src/Core/Services/MetadataProviders/SqlMetadataProvider.cs:line 1116
at Azure.DataApiBuilder.Core.Services.SqlMetadataProvider3.PopulateObjectDefinitionForEntities() in /_/src/Core/Services/MetadataProviders/SqlMetadataProvider.cs:line 1054 at Azure.DataApiBuilder.Core.Services.SqlMetadataProvider3.InitializeAsync() in //src/Core/Services/MetadataProviders/SqlMetadataProvider.cs:line 289
at Azure.DataApiBuilder.Core.Services.MetadataProviders.MetadataProviderFactory.InitializeAsync() in //src/Core/Services/MetadataProviders/MetadataProviderFactory.cs:line 65
at Azure.DataApiBuilder.Service.Startup.PerformOnConfigChangeAsync(IApplicationBuilder app) in //src/Service/Startup.cs:line 613
info: Microsoft.Hosting.Lifetime[0]
Application is shutting down...
fail: Azure.DataApiBuilder.Service.Startup[0]
Could not initialize the engine with the runtime config file: .\dab-config.mssql.json
fail: Microsoft.Extensions.Hosting.Internal.Host[11]
Hosting failed to start
System.Threading.Tasks.TaskCanceledException: A task was canceled.
at Microsoft.AspNetCore.Server.Kestrel.Core.KestrelServerImpl.BindAsync(CancellationToken cancellationToken)
at Microsoft.AspNetCore.Server.Kestrel.Core.KestrelServerImpl.StartAsync[TContext](IHttpApplication1 application, CancellationToken cancellationToken) at Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken) at Microsoft.Extensions.Hosting.Internal.Host.<StartAsync>b__15_1(IHostedService service, CancellationToken token) at Microsoft.Extensions.Hosting.Internal.Host.ForeachService[T](IEnumerable1 services, CancellationToken token, Boolean concurrent, Boolean abortOnFirstException, List1 exceptions, Func3 operation)
Unable to launch the Data API builder engine.

Thanks for your help.
Nadine

[vadeveka]

You will want to remove the tcp: prefix from the connection string, that is not supported by Fabric warehouse. Also the database-type should be dwsql.
The config should look something like this:

  "data-source": {
    "database-type": "dwsql",
    "connection-string": "Server=SERVERNAME.datawarehouse.fabric.microsoft.com;Initial Catalog=dabtest;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication=Active Directory Default;"
  },

[Sezal Chug (sezal98)]

Resolving issue now. Please reopen in case issues faced again