Loading data from stored procedure into fabric lake house

[Jostnach]

Hi All,

I have a Stored procedure and i woud like to load this data to lakehouse and eventually connect it to power BI using Direct lake mode.

Is it acheivable? can someone guide me on this please!!

Regards,

Jostna

[Anonymous]

Hi  @Jostnach ,

Please try below steps:
1. create a Dataflow Gen2 with SQL Server in Power BI Service, click Advanced options, input the sql statement to execute store procedure
2. create a Lakehouse with Dataflow Gen2
3. create a semantic model.

Refer to:

How to use SQL Server stored procedures in Microsoft PowerBI? - Stack Overflow

Learn how to create a Lakehouse for Direct Lake in Power BI and Microsoft Fabric - Power BI | Micros...

Learn about Direct Lake in Power BI and Microsoft Fabric - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jostnach]

Can we do it with direct query mode? can u please guide on that please