Forum Discussion
Loading data from stored procedure into fabric lake house
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
2 Replies
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 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.
Can we do it with direct query mode? can u please guide on that please
