Forum Discussion

howellchrisj's avatar
howellchrisj
Icon for Helper I rankHelper I
4 years ago

Direct Query Date Slicer - Generated SQL is different

I am running into a Direct Query that is taking a while to execute and pull back results when a Date slicer is utilized from the dimDate.Date field.  I currently have the following data model below a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi howellchrisj ,

 

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

 

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • howellchrisj's avatar
    howellchrisj
    Icon for Helper I rankHelper I
    4 years ago

    Anonymous , amitchandak 's solution is a solution but doesn't truly solve the issue.  
    I was able to get additional details from Chris Webb that the reason for the splitting of the dates in the SQL was due to the difference in the data sources.  I was able to test this and validate it.  If you have a direct query data set related to an imported data set, for some reason the SQL Generated by Power BI is not effectively created.  I am not sure why this is the case, but for now, it is.