HELP ! Writeback in Fabric lakehouse using DirectLake Mode

Hi All,

Recently our team has been testing writeback (making edits to the data source directly from PowerBI Report (any UI)).

Currently working stack : Fabric Lakehouse, PowerBI Report, Powerapps

__________________

Approach:

Created a new lakehouse in fabric and then uploaded few csv's and started working with these as tables.

These tables were loaded into a new semantic model (non-default) for usage.

Now we have the powerbi report use this semantic model for reporting.

In the powerBI we embed a powerapp visual.

We edit the powerapp visual for new app creation.

Here in the powerapp the connection is done using the lakehouse sql endpoint.

_________________

!!!!!!!!!!!!!!! Main Concern !!!!!!!!!!!!!!!!!!!!!

The approach use needs an primary key for performing edits to the data source.

*** Fact being : I have looked at few blogs for guidance on how to workaround for the primary key creation in lakehouse, but wasn't able to do so.

________________

Any suggestions are welcomed, happy to cross check for validation and working.

2 comments

skool.com/microsoft-fabric

Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.

Leaderboard (30-day)

+32

+24

+19

+15

+14