topic Re: How to Ingest Stored procedures from Azure SQL DM to Fabric Onelake/Bronze lake House in Data Engineering

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

Karthick_Balaje — Sat, 30 Aug 2025 00:53:48 GMT

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

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

spaceman127 — Sat, 30 Aug 2025 06:34:36 GMT

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

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

Shahid12523 — Mon, 01 Sep 2025 07:45:57 GMT

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.

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

v-prasare — Fri, 05 Sep 2025 09:44:02 GMT

Hi Karthick_Balaje,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Shahid12523& spaceman127, Thanks for your prompt response

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are

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

anilgavhane — Fri, 05 Sep 2025 10:51:44 GMT

Karthick_Balaje

1. Convert Stored Procedure Logic into a View

Create a SQL view that replicates the logic of your stored procedure.
Use Dataflow Gen2 or a Pipeline in Fabric to ingest the view into your Lakehouse.
This is the cleanest and most scalable method.

2. Use a Staging Table

Modify your stored procedure to insert results into a staging table.
Then use a Copy Data activity in Fabric to move that table into your Bronze Lakehouse.

3. Use Script Activity in a Pipeline

Fabric Pipelines support Script activities that can execute stored procedures.
After execution, use a Copy activity to move the resulting table into the Lakehouse.
Microsoft’s tutorial on preprocessing with stored procedures walks through this step-by-step.

4. Replicate Logic in Fabric

If the stored procedure uses functions like TimeValue, consider replicating that logic in Dataflow Gen2 using Power Query M.
This avoids dependency on SQL Server functions and keeps the transformation native to Fabric.

Next Steps

Choose the method that best fits your architecture and governance model.
Once the data lands in the Lakehouse, Power BI can connect directly to the default dataset or SQL endpoint for visualization.

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

v-prasare — Tue, 09 Sep 2025 09:13:31 GMT

Hi Karthick_Balaje,

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are

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

v-prasare — Tue, 16 Sep 2025 06:29:08 GMT

May I ask if you have resolved this issue? If so, Can you please share the resolution steps here. This will be helpful for other community members who have similar problems to solve it faster.
If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.

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

Karthick_Balaje — Thu, 25 Sep 2025 19:57:21 GMT

My Query is Resolved, and Thank you anilgavhane v-prasare Shahid12523 for the responses!