PowerBI List all dates with DirectQuery

[Anonymous]

Hello,

I have a dataset that I need to use DirectQuery on however I am running into a problem with the data as I have 2 tables one that has a date range and one that has the actual day. They are related by a ID but the ID covers multiple spots in the date range table so I am trying to create a MERGE but am needing to make the DATE RANGE show days so I can merge them properly. 

With that, is there anyway using Direct Query to replicate the below in PowerM? This works for me, but it requires IMPORT mode. Is there anything in DQ mode that can replicate this functionality so I can get the data to correctly merge? 

{ Number.From([StartDate])..Number.From([EndDate]) }

Thanks in advance. 

[lbendlin]

Create a view in your data source and consume that view via Direct Query