topic Re: Failed to load table preview data You are trying to read a table without columns using Delta in Dataflow

Failed to load table preview data You are trying to read a table without columns using Delta

Anonymous — Thu, 28 Sep 2023 13:35:03 GMT

I have loaded an excel sheet into Fabric Data Lakehouse using Dataflow Gen2 but when I try to open it I get the below error. other tabs from the same excel are working.

Failed to load table preview data
You are trying to read a table `delta`.`path/filename' without columns using Delta.

This excel has some formatting which I suspect is breaking something when it gets converted to a delta file. However I am unable to work out what is causing the issue. Once I know then I can ask the owner of the sheet to remove the formatting. Any ideas would be appreciated

Thanks

Re: Failed to load table preview data You are trying to read a table without columns using Delta

miguel — Thu, 28 Sep 2023 15:37:33 GMT

Hi!

Where exactly are ou seeing this error? is it in the Lakehouse experience or inside Dataflows Gen2?

Re: Failed to load table preview data You are trying to read a table without columns using Delta

Anonymous — Thu, 05 Oct 2023 18:17:08 GMT

Hi Anonymous ,
We haven't heard from you and hence following up if you could provide more details regarding your error.
Kindly provide the screenshot for better understanding of the issue.

Re: Failed to load table preview data You are trying to read a table without columns using Delta

Anonymous — Sat, 07 Oct 2023 09:50:22 GMT

Hi Anonymous ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet . Please do let us know if you have any further queries.

Re: Failed to load table preview data You are trying to read a table without columns using Delta

Anonymous — Mon, 09 Oct 2023 07:31:54 GMT

Hi - I have resolved the error . The issue is related to the load from excel . I see you must convert the columns to either text or some other type otherwise the coulmns are not pulled through. My assumption was that the coulmns would all come through as text if you don't convert them. This would seem like a better behaviour. Currently everything works but only converted columns pull through .If you don't convert any columns then nothing comes through - hence the error. The other issue is the sheetes I am pulling from could potentially change but any new columns would not come through automatically which is a pain. Can we change this behaviour please

Re: Failed to load table preview data You are trying to read a table without columns using Delta

Anonymous — Mon, 09 Oct 2023 08:28:05 GMT

Hi Anonymous ,
Thanks for using Fabric Community and reporting this.

Appreciate if you could share the feedback on our feedback channel, which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Feedback Link: https://ideas.fabric.microsoft.com/

I hope this information is helpful. Please let me know if you have any other questions.