topic Re: Azure DB connector in Data Movement & Streaming

Azure DB connector

arnbank — Wed, 19 Mar 2025 22:43:16 GMT

I want to make a connection to MS Dataverse. based on MS documentation I found that it is possible to make a connection directly to SQL DB.

Use SQL to query data (Microsoft Dataverse) - Power Apps | Microsoft Learn

I tested this connection on my PC and all works fine I connected to DB.

I made this Connection on Qlik

When I created a connector and tested that it was successful.

issue when i try take data i get this error:

Re: Azure DB connector

p_verkooijen — Tue, 05 Mar 2024 12:48:15 GMT

@arnbank did you manage to resolve this issue?

Re: Azure DB connector

arnbank — Tue, 05 Mar 2024 13:52:55 GMT

@p_verkooijen

and yes and no. In general created connection is working and if you try to load something like this:

LIB CONNECT TO 'LTP Group - Furniture:Dataverse SQL';

TMP:
LOAD *;
SQL
SELECT TOP (1000) *
FROM [dbo].[report]
;

you will get data from Dataverse. but if you want to use the Qlik selector tool then I still have the same issue 🙂 I developed my queries in SSMS and then I just copied them to Qlik.