Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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

Status: 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

Comments
sukkaur
Microsoft Employee
Status changed 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
Regular Visitor
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
sukkaur
Microsoft Employee

@TalentBridge - Please open a support case for your issue.

Thanks

Sukhwant