I would like to be able to create an entity based off of a custom SQL Query instead of having to use the Power Query tools. The problem I am having is that one of the tables I am working with is too...
This is something that we have found ourselves by surprise in a client (since we have not seen in any detailed site this limitation). The solution we have found at the moment is to create a view with that query, and once created select that view from the list of objects that appear (tables and views) when connecting to the corresponding database. But, obviously, this is a workaround. We also need to execute native query in dataflows
