Change the source of data inside PBI, from Database tables to Lakehouse tables

[tan_thiamhuat]

I have a dashboard built in PBI, which links to the database tables of Dimension and Fact tables.

I want to bring this dashboard inside Fabric, which needs to link to the same identical tables of Dimension and Fact tables, which are in the Lakehouse.

I am able to import that PBI, but how do I change those tables inside PBI to point to those tables inside the Lakehouse? So, by right, if the change of source from Database to Fabric Lakehouse is successful, the results on the dashboard should be the same, since both sets of tables are identical.

I hope I do not need to de-design the whole dashboard all over again in Fabric.

Thanks.

[Vinodh247 · Accepted solution]

Using PBI Desktop, try the following steps if not yet.

1. Download the PBIX file from Fabric.

2. Open the PBIX in Power BI Desktop.

3. Go to Transform Data -> Data Source Settings.

4. Click Change Source.

5. Replace the existing SQL database connection with a connection to your Lakehouse:

   • Use the "Lakehouse" connector from PBI.

   • Point it to the desired lakehouse and tables inside your Fabric workspace.

(If the schema (table and column names) are same, PBI will automap the queries. Otherwise, you may need to adjust power query steps)

1. Click Close & Apply.

2. Validate the visuals (measures, visuals, filters) still render as expected.

3. Save and publish the report back to fabric

Note:  Data Types: Ensure data types between SQL and Lakehouse are consistent, else visuals or measures may break. Relationships: Re-check the model relationships after change.