Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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