Forum Discussion

fabiosalles6's avatar
fabiosalles6
Regular Visitor
8 years ago

Power BI Report - Get last data from stream analytics

Hello,   I created a DataSet in Stream Analytics that fills an output for Power BI, but I can not use the information in this DataSet to make filters, for example, with the "Data".   I tried form...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

 

I need to get the last record.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


I can not use the information in this dataset as a filter, DAX formulas are not returning the expected value.

fabiosalles6,

Do you connect to the dataset in Power BI Desktop and use DAX?

Regards,
Lydia

fabiosalles6's avatar
fabiosalles6
Regular Visitor
8 years ago

Hi Lydia,

 

Yes, I connect to Power BI Desktop and run this:

 

Measure = var last_date = MAX(Table1[EventProcessedUtcTime]) return CALCULATE(LASTNONBLANK(Table1[Temperatura_massa];1); Table1[EventProcessedUtcTime]=last_date)

 

 

Regards,

 

Fabio Salles

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    fabiosalles6,

    I create a streaming dataset in Power BI Service following the guide in this blog, then connect to the dataset in December update of Power BI Desktop and create the measure  using DAX as yours, I can get last data without any issues.

    When I click refresh in Power BI Desktop, the measure updates correctly. Do you use the latest version of Power BI Desktop? Could you please try the stream dataset in  that blog?

    Regards,
    Lydia

    • fabiosalles6's avatar
      fabiosalles6
      Regular Visitor
      8 years ago

      Lydia,

       

      Thanks for the tip.

      In this guide, they show how to do on the dashboard, but I need this information on the report.

       

       

      Regards,

       

      Fábio Salles

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        fabiosalles6,

        I understand your requirement. I recommend you create the same stream dataset as described in the blog, then connect to the dataset in your Power BI Desktop and check if you get last data with your measure.

        Regards,
        Lydia