Power BI report to MS Fabric LakeHouse

[dan5460]

Hi,

I have a tricky one here and I am not sure if it belongs under this topic.  I have a Power BI Dashboard that has several pages.  There are several tables and views from an on premise SQL Server databases as the source.  It points directly to the database.  I am now starting up with MS Fabric and OneLake.  Instead of recreating the wheel, by recreating all the sources in the Lakehouse, is there a way, I can take the sources from the PowerBI report and import them into a LakeHouse?  I would hate to re-create the entire PowerBI report and sources.  I would not mind recreating the PowerBI Report, but it would be nice, if I can migrate the sources and all of the transformation that goes with it.  A lot of them uses PowerQuery to prep the data.  I tried to google and ChatGPT and Gemini AI and there is really nothing out there. 

Any suggestion would be great.  

Thank you in advance

[SaiTejaTalasila · Accepted solution]

Hi @dan5460 ,

Please refer this -

https://data-mozart.com/migrate-existing-power-bi-semantic-models-to-direct-lake-a-step-by-step-guid...

I hope it will be helpful.

Thanks,

Sai Teja 

[NandanHegde]

Hey,

So is your ask to do a 1 time export of data from Power BI into your lakehouse? 

[dan5460]

Hi there, 

Yes, correct.  I want to move the source of that report to the lakehouse and then repoint the Power BI to the lakehouse.  Or I can recreate the Power BI by re-selecting the lakehouse as the source.  It is a one time deal to copy and setup the sources to Lakehouse.  

Thanks

[FarmerD]

Still no luck here?  Seems like the Power BI model sitting in the workspace would be an option for consumption from a Data Flow Gen2 or a Pipeline.  I can't find that and I have found similar, statements like "Export the PowerQuery Transformations", I could not find how to do that.  I could not find a way to store that I did find the Connector for the Semantic Model but no where to use it.  Seems like a big oversight to be unable to migrate Power BI Models to a Fabric Lakehouse. <sigh>  Guess I need to build everything anew.  

[FarmerD]

Well, I thought about it... unless you have a static data set you will want a data flow to refresh the data.  Maybe they purposely left it out so you don't get yourself stuck in a deeper hole.  I'm going to take my static / legacy data and move it in raw / bronze via tables probably, unless I can get the ODBC connection working.  Then I'll use advanced editor to copy and paste the code from Power Query.

[v-yaningy-msft]

Hi, @dan5460 

Based on your description, you are looking to implement a migration of Power BI sources, including PowerQuery transformations, to MS Fabric LakeHouse. You can try using DirectLack to fulfill this requirement.

1. Export the PowerQuery transformations and ensure that all PowerQuery transformations have been properly logged or exported.

2. Import the data into LakeHouse and utilize DirectLake schema for seamless integration between Power BI and MS Fabric LakeHouse. This schema is designed for high-performance querying and reporting directly from LakeHouse One. You can start creating LakeHouse and importing data by following the steps outlined in the link below.
Related links:
What's new? - Microsoft Fabric | Microsoft Learn
Direct Lake (sharepoint.com)

3. Migrate PowerQuery transformations directly to LakeHouse in a LakeHouse environment using the data engineering tools in MS Fabric (e.g., Apache Spark library in notebook code or Setup Data Flow).
Related link: Migrate Hive Metastore metadata - Microsoft Fabric | Microsoft Learn

4. Relink Power BI reports to LakeHouse: After successfully importing and transforming data in LakeHouse, you can connect Power BI reports to the LakeHouse data source.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[dan5460]

Hi there, 

Thank you for your response.  That is what I am attempting to do.  FYI, I am currently using the Trial Version of MS Fabric for testing some use case scenerios.  The current Power BI report gets the data from a MS SQL Database.  This report consists of 10 tables/views.  The major problem I have is how do I extract the data source queries from the current Power BI Report and add it do a Lakehouse.  I am assuming I would import the query.  I cannot find where to export the query and in what format.  I use both Web and Desktop Version of Power BI.  Is there also a way to extract all the 10 tables/view that the old Power BI report is using into a Lake house?  

Thanks in advance. 

Danny Valenzuela

[aohara15]

Hello, I am in the same boat as you and cannot find anything online that helps me. Were you able to figure this out?