Forum Discussion
OLE DB or ODBC error
Hi, so today I tried to add a new table to PowerBI only instead it started giving me a lot of errors on older tables. I managed to get rid of most of them now but am now stuck at the one below:
Its giving this error for about every single table I am trying to refresh but the odd thing is that in the power query editor, I can see it perfectly fine in the preview. The power query itself also does not display anything weird that could be causing this.
I am importing my data from a synapse SQL pool.
Another thing that might help is that when I try refresh my data, at a moment it open a second window for a 10th of a second and then it gives the error. No clue what this screen is though.
I tried searching other forums but wasnt able to find a solution that worked for me.
Thank you for your assistance, eventually I managed to find the stupid mistake myself and that was that in a union I was doing, there was 1 singular column that switched with the one below it in the create function.
