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...
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/