title: Trying to display window date of Azure Stream Analytics with PowerBI
body: <p>I'm trying to do a TumblingWindowing in Azure Stream Analytics with the following query:</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT
        System.Timestamp() as SysDate, 
        Types,
        Brands,
        SUM(Price) as SumPrice
  INTO
      Output
  FROM
      Source
  TIMESTAMP BY
       CAST(Date as DATETIME) #This is the source data Date field 'Date'
   
  GROUP BY
     TumblingWindow(minute,5), 
     Types, 
     Brands
  </code></pre>
  <p>In the UI of the ASA I can see that I'm having the desired output:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>SysDate</th>
  <th>Types</th>
  <th>Brands</th>
  <th>SumPrice</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2021-01-26T08:10:00.0000000Z</td>
  <td>T1</td>
  <td>B1</td>
  <td>29,00</td>
  </tr>
  <tr>
  <td>2021-01-26T08:10:00.0000000Z</td>
  <td>T2</td>
  <td>B2</td>
  <td>67,00</td>
  </tr>
  <tr>
  <td>2021-01-26T09:05:00.0000000Z</td>
  <td>T3</td>
  <td>B2</td>
  <td>89,00</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>For some reason, when I enter this data in PBI it is taking the date of creation of the event in Eventhub and not the date that comes inside the event. You can see that the windowing does it well, but once it is shown in PBI it does not take into account the date of the data but the date of the event creation.</p>
  <p>In the UI of ASA I can see dates from january and in PBI is getting from today (Frebuary)</p>
  <p>What is happening here?</p>