Forum Discussion

AyusmanBasu0604's avatar
10 months ago
Solved

Fabric Data Agent - SQL DB source unavailable?

While trying to add Data Sources in the Fabric Data Agent I could see the following types visible in OneLake: 1. Warehouse (Lakehouse) 2. Semantic Model 3. Mirrored Database 4. Lakehouse   Don'...
  • v-achippa's avatar
    10 months ago

    Hi AyusmanBasu0604,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you for raising this. Currently the Fabric Data Agent supports Lakehouse, Warehouse, Semantic Model and Mirrored Databases as data sources. Fabric SQL Database is not yet available as a native source in the Data Agent UI. This is a known limitation and is planned to be addressed in future updates.
    As of now you can work around this by mirroring your sql data into Fabric or staging the data into a Lakehouse and using that as your source. Support for Fabric SQL Database as a native source is already on the product roadmap and is expected to roll out later this year.

     

    Thanks and regards,

    Anjan Kumar Chippa