Forum Discussion
Unable to Sort Dataflow Column
Everything I'm finding says that Native Queries/Query Folding isn't available in Dataflow yet?
Right. I think I should stop talking. I clearly have no idea what the issue could be.
What's the reason for going dataflows?
Oh crap, thanks for trying!
I'm attempting to convert some SSRS reports that a colleague of mine created. We're hoping to deprecate SSRS before it's deprecated on us and we're left without a solution. Since the Report Builder requires Premium Access I have been using his queries to recreate. I've found that trying to make little changes in Power Query forces import which I have found essentially useless. It takes so long to import tables that I freeze the SQL server. This is problematic since my Operations team is still in need of pulling reports off the server.
Dataflows allows me to use the query, make little adjustments here and there, and then refresh whenever I choose.
I was able to accomplish everything I'm trying in Power Query (dataset) but the loading of tables was causing problems which is why I opted to go the Dataflow route with this particular report. I don't understand why I receive that error on a sort of a column that comes directly from the DB?