Forum Discussion

BharathKumarS's avatar
BharathKumarS
Regular Visitor
5 months ago
Solved

SSRS with Fabric as a source

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?

SQL database
  • Jarrinf's avatar
    Jarrinf
    5 months ago

    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:

     

     

     

3 Replies

  • Jarrinf's avatar
    Jarrinf
    Frequent Visitor
    5 months ago

    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:

     

     

     

  • v-priyankata's avatar
    v-priyankata
    Community Support
    5 months ago

    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's avatar
      v-priyankata
      Community Support
      5 months ago

      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.