Hi I was trying to see what SQL queries does my Power BI report generate for the DB, and in my case i was trying a paralelperiod function to see how it is generated in the DB. I´m using a Direct Query connection to my DB in Vertica. This is the example DAX query:
When I evaluate the query in DAX Studio I get that the selection of DATES for the query is done one by one with an IN. The column D_DT is Date Time format and when I see the SQL query in DAX studio the result is this:
If you look the scrollbar you realize there is a huge amount of Dates written one by one.
So my doubt is , isn´t this very inefficient? Wouldn´t it be better just to use a BETWEEN or any other way more efficient rather than generate all the DATES that is going to use one by one?
Thanks for your time!
Solved! Go to Solution.
I have just tried it and it works in the same way. I´m not searching for a practical solution though, I´m just trying to know why it works the way it does and not other way that for me would look more efficient. But thank you anyways for the response.
Not really ,I was just asking myself why this was the way parallelperiod worked existing the other ways. But I also agree with you, the developers may have a reason for it
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps