How to Ingest Stored procedures from Azure SQL DM to Fabric Onelake/Bronze lake House

[Karthick_Balaje]

Hi All!

I have been stuck with this blocker while working on a task. I wanted to use a stored procedure and TimeValue Function from Azure SQL DB and build a KPI in Fabric. But I am stuck with this blocker for over 4 to 5 hours, so I thought to post it here. And my task needs to be done so that Power BI resource can work on the visualization. How to approach this issue? 

Thanks and Regards!
Karthick

[Shahid12523]

You can’t ingest stored procedure results directly into Fabric Lakehouse.
Workarounds:

Best → Convert SP logic into a view and ingest via Dataflow Gen2/Pipeline.

Else → Make SP insert results into a staging table, then copy that table to Bronze Lakehouse.

Pipeline option → Use Stored Procedure activity (if enabled) to execute SP and land output in Lakehouse.

Transform in Fabric → Replicate SP logic (like TimeValue) in Dataflow Gen2 instead of DB.

[spaceman127]

Hello @Karthick_Balaje ,

So, if I understand your headline correctly, you want to use Azure SQL Proc to load data directly into a lakehouse.

- Is there an error message?

- Do you use a data pipeline?

There are several ways to achieve your goal.

Here is an example of how to load data into the lakehouse.

https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-move-data-lakehouse-pipeline

Please give us a little more information so we can help you.

Best regards