SSRS with Fabric as a source

Question

SSRS with Fabric as a source

BharathKumarS-1759 65

Hi All,

Is it possible to have a Fabric SQL database/ Fabric warehouse as a datasource for SSRS report?

There is no proper documentation which I could see across. Fabric sources doesn't support SQL auth,

So is it possible to access them via SSRS via service principle or OAUTh?

1 answer

Your answer

Answer 1

Marcin Policht 82,360 MVP Volunteer Moderator

You could create a middle-tier service or custom SSRS data extension that handles Entra ID authentication, acquires an access token, and then passes queries to the Fabric warehouse using that token. For example, in C# you might acquire a token using the Microsoft.Identity.Client library and then use it in your connection string as a bearer token:

var app = ConfidentialClientApplicationBuilder.Create(clientId)

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator

2026-03-03T10:15:14.91+00:00

Hi BharathKumarS-1759,

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further

Thanks,

Lakshmi.
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator

2026-03-10T09:05:48.53+00:00

Hi, BharathKumarS-1759,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Thanks,

Lakshmi.

Share via

SSRS with Fabric as a source

1 answer

Your answer