The new EVALUATEANDLOG DAX function is great, but how do you actually use it in conjunction with SQL Profiler. This articles shows how and also demonstrates how to configure SQL Profiler as an external tool for Power BI Desktop.
If you use power bi direct query, you can define a date table at the source or in power bi. You can create a date table in Power BI. The table created in Power BI is in import mode. Power BI will enable mixed-mode queries.