Forum Discussion
Microsoft Query invalid column name
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 databas...
Why do you have to use MSQuery? Alternatively, why not use the more modern tools (Get&Transform from the Data tab)?
JKPieterseI need to use parameters to filter my query and unfortunately only Microsoft Query supports that
- You can do this using PowerQuery, see: https://reevessmith.wordpress.com/2014/08/19/power-query-and-stored-procedures-with-parameters/