Forum Discussion

New Member

2 years ago

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 p...

Need Help

Anonymous

Not applicable

2 years ago

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 | Microsoft Learn

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.