Hello everyone, I am working on a large dataset with 1.8M rows and 150 columns, until a few days ago everything was working fine then I did some transformation and now when I load the query in Powerbi I get this error:
OLE DB or ODBC error: [DataSource.Error] Received an unexpected EOF or 0 bytes from the transport st..
I am quite new to this world and I can't seem to solve this, I have isolated some steps that seem to be creating problems.
(When individually changing/deleting each step the query loads correctly in Pwbi)
My Issue is that I do not see any problem in those problematic columns, at least not from power query, all values are rendered correctly and there are no weird situations at first glance therefore I do not know where to fix what. The only thing that I have noticed is that it takes a lot of time to load all the query in powerbi (20 min at least) and maybe there is a different way to organized the data.
You can find all the files here: https://we.tl/t-pEJ3Z4qqFg
The problematic steps are under the query "LOP" and are called:
- #"Merged GEO_BBH_Diameter"
- #"Merged GEO_Diameter"
- #"Merged GEO_Thickness"
- #"Merged GEO_Height"
- #"Merged GEO_Width"
- #"Merged GEO_Length"
- #"Merged RVT_Struct Mat"
- #"Merged BBH_Material
Thanks to everyone for the help! Any input will be highly appreciated.
Simone
