Forum Discussion
JoachimSA
Helper II
Helper IIRead & Manipulate Delta Table from Lakehouse in Excel via Power Query
Hi everybody, I have a scenario where I produce a table of 1000 - 2000 Rows in a Fabric Lakehouse using a Fabric Notebook. I now want to manipulate individual Cells and load that manipulated tab...
JoachimSAHelper II
Helper IIIt does seem that there is no direkt way to get Deltatable into Excel at the moment.
I would be very interested to know whether Microsoft is planning to implement the DeltaLake.Table into PQ in Excel as well. Would be very welcome 🙂
I helped myslef by using a Dataflow Gen1 to get the Delta Table and then connecto to it with PQ in Excel. Seems unnecessarily cumbersome with 1 hop to many.
I also thought about using the Notebook that is creating the Delta Table to also/instead write a .csv or maybe even Excel into the lakhouses Files Area to access that directly with PQ in Excel.
Havent tried that yet.
I would be very happy to hear any suggestions on how to make this a less cumbersome endeavour 😉
Best regards,
Joachim