How to remove dataflow and link dataset directly to my source (SQL server) ?

[Tejinder]

I have a few reports that are created from the same data flow. Now I have to reduce the size of my refresh to reduce CPU usage of our SQL server. 

I am using a Pro licence and upgrading to a PPU or Premium workspace is not an option. So I can not use the incremental refresh option in dataflows.

The only viable option to reduce refresh size is to use an incremental refresh in the dataset when publishing the report. 

My question is, how do I remove dataflow and link my current dataset directly to my SQL server, I don't want to recreate any reports.

[lbendlin · Accepted solution]

Create an import mode data source pointing to your SQL Server that produces EXACTLY the same output as your dataflow.  Swap the code in, leaving the query name the same.  This will only work if the resulting meta data is EXACTLY the same.  Any little deviation will result in loss of measures, groups, and sorts. Back up before you try this.