Forum Discussion
Solved
Combining Databases from OneLacke and from local source in Power BI Desktop
My goal is to combine a database imported from the cloud and processed via OneLake Lakehouse and combine it with a local database (private data) in Power BI Desktop. I built and processed the data...
Hi abde139,
When you use OneLake connector in Power BI Desktop, it is like a live connection, therefore you can't edit it.
It is basically a DirectLake connection.
You can read more about it here:
https://learn.microsoft.com/en-us/power-bi/enterprise/directlake-overview
To combine your data coming from cloud database & Local file, I would suggest you use Dataflow Gen2 to combine these two and write the combined data to your OneLake.
Once you have your combined data in OneLake, you can consume it in Power BI Desktop like you are doing now.
