Cedric Charlier ran into an error running native queries in his Visual Studio M project:
I was just using it since a few days when I found an interesting case. My query had a native query
Sql.Database(“server”,“db”,[Query = “select * from myTable where field=” & value])When I tried to execute it, I received a message from the Power Query SDK that
The evaluation requires a permission that has not been provided. Data source kind: ‘SQL’. Permission kind: ‘NativeQuery’.
Read on for the solution.