Something new came out just a few weeks ago. We now have the ability to connect LIVE to a SQL Database and use Power Query to create our Query that will later be used in our Power BI Desktop. This is simply AMAZING!! this uses the new SSAS Tabular engine in Direct Query mode, but we can't add Measures, Calculated Fields or Calculated Tables...yet. This should be a fairly simple request. Please let us add our measures so we can create the Model that we need in real time 🙂
... View more