Forum Discussion
Dataflow with SQL Server On-Prem and Gateway: A non-serializable exception was encountered.
Hello, I installed the gateway and configured SQL Server Data Source. It works when I'm using navigation pane and select table but when I want to use query instead e.g. select top (100) * from [sche...
Instead of inserting a SQL Query in M code, have you tried to simply get the data first into the Power Query editor (by just selecting the data source using the GUI) and then use the menu/toolbar functionality to filter the data according to what you want?