Dataflows from Custom SQL Query

[chass]

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 large and results in a timeout when Dataflows tries to bring it in. I think that a custom SQL Query will alleviate this issue by allowing me to prefilter my data before it comes into Dataflows.

[frederick_dieri]

The data source "blank query" is not working while refreshing. This is a must have functionality (pre-filter data). I understand that dataflow is still in preview, so probably (and I hope) it will be available soon.

[dpual1031]

I am struggling with this too. And need a solution. I created my tables by creating the table as a datasource first. the query runs perfect and returns my data and creates a table in Power BI. I copied the 'M' code from the data source. and tried to create a dataflow using the 'Blank Query'. I pasted the 'M' code into the Source - see below - and selected the data gateway for the this source. No dice! The system comes back with an error: 'There is an error in the query' ARGH!!! so frustrating. and there is no place to go to get feedback. let Source = Sql.Database("SQ-ENT12-P02\PROD2", "RPT_CARE", [Query="Select [ProgramStatusId], [ProgramStatusCode], [ProgramStatusDescription], [ActiveStatus], [CertifiedStatus], [VerificationStatus] FROM [dbo].[Code_ProgramStatus]"]) in Source