Ok I have a weird one I have no idea how to get around.
When I want to get the data from my online form through power query (.xlsx format .xls also) it gives me the 1 (1 picture) error but the column can be seen in power query editor (picture 2).
Also if I download form directly from the page as in XLS file everything works. As I am trying to make an automatic reporting system for our organization that is really problematic.
Any suggestions would be appreciated