Mar 02 2020 11:32 PM
Hi,
I'm trying to import MSSQL view through Microsoft Query import in Data tab. It fails to load most likely due to Czech language encoding (column names)
Tried loading it through SQL database option and it worked, unfortunately I have to use Microsoft Query importing option. Double checked excel language settings and seemed fine to me. I ran out of ideas here fellas. Appreciate any help!
Mar 03 2020 01:23 AM
Mar 03 2020 02:07 AM
@Jan Karel PieterseI need to use parameters to filter my query and unfortunately only Microsoft Query supports that
Mar 03 2020 02:20 AM
Oct 28 2020 11:17 AM
@janjanacek I had the same problem, and my query was very clean and didn't have much complexity at the moment when I got that message.
I had to go back to the query, unmerged some of my merged columns, i.e. deleted the step, and refreshed all while in the query. After these steps, it was able to load to the table.
So check your merged column steps and refresh all queries before loading to file.