garddolau's avatar
garddolau
Icon for Advocate IV rankAdvocate IV
1 year ago
Status:
Completed

Fabric SQL Database - Available via Data Pipeline Stored Procedure Activity

Tried using Fabric SQL database to hold the metadata tables for metadata driven ingestion.  Fabric SQL Database is not supported as source in stored procedure activity in pipelines.  We need to update log tables in our metadata db by using the stored procedure activity.  Is adding Fabric SQL Database in stored procedure activity on roadmap soon?

 

Without this option available Fabric SQL database is not a viable option to replace an Azure SQL DB at this time.

Please prioritise this option, Fabric SQL database is available in the Data Pipeline lookup activity so hopefully not to much much effort to also add to stored procedure activity.

 

Thanks

Data Factory | Pipelines
Databases | SQL Database
fabric platform

3 Comments

  • sukkaur's avatar
    sukkaur
    Icon for Microsoft Employee rankMicrosoft Employee
    1 year ago
    Status changed:
    New
    to
    Completed

    garddolau - Stored Procedure activity in pipelines does let you choose SQL database in Fabric as a source now. Please try this functionality and let us know your feedback.

    Thanks

    Sukhwant

  • TalentBridge's avatar
    TalentBridge
    Regular Visitor
    1 year ago
    Thank you for the update, Sukhwant. I am currently experiencing an issue with the "Paginated Reports" capacity being stopped or paused, which is preventing the creation of new sessions. The error details are as follows: Timestamp: 2025-05-06T21:00:10.618Z Root activity ID: 58b8f28e-47ce-2ba5-53b6-3d37a12f8af4 Tenant ID: 319c9d59-c5f1-48d3-af49-4f959b5e02c1 Cluster: https://319c9d59c5f148d3af494f959b5e02c1-api.analysis.windows.net/ Report ID: dca60590-2adc-49c7-af90-8e501ae8444a Capacity ID: undefined ReportViewerVersion: 2025.5.1.1820 Could you please assist in resolving this issue or provide guidance on how to proceed? Best regards, Moazzem Hossain

Recent ideas