SSRS with Fabric as a source

[BharathKumarS]

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?

[v-priyankata]

Hi @BharathKumarS 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@Jarrinf Thanks for the inputs.

I hope the information provided by user was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @BharathKumarS 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

[Jarrinf · Accepted solution]

We did it, by using the SQL Endpoint and SQL Server user/password credentials.

You need to update the Reporting Services to the latest version: