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...
It appears that there is currently no direct method for importing Deltatable data into Excel.
If Microsoft intends to use DeltaLake, it would be extremely interesting to know. Additionally, table becomes PQ in Excel. Would be greatly appreciated: A faint smile on the face:
I assisted myself by obtaining the Delta Table using a Dataflow Gen1 and connecting to it in Excel using PQ. It seems needlessly complicated and one jump too many.
In order to access that directly with PQ in Excel, I also considered writing a.csv or possibly even an Excel file into the Lakhouses Files Area using the Notebook that is building the Delta Table.
I haven't yet attempted that.