Forum Discussion

demokedes's avatar
demokedes
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Calculating a sum for each day

Dear all, I am newibie in power bi.  I am using Azure IoT hub for tracking measures from my IoT devices. Than I am streaming all this data into PowerBi Service. So i have different datasets. In one...
Need Help
Show and Tell
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi demokedes ,

     

    You can send data from stream analystics to Data Lake, and then use Power BI Desktop to connect to Data Lake to calculate a sum for each day.

    You can also refer to this:https://codez.deedx.cz/posts/from-iot-hub-to-powerbi/ 

    Extracting the date field from the time is helpful for your calculation.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

It's been a little bit since I worked with streaming datasets. Is it a stream coming into Power BI, as in it comes in real time to a dashboard tile? If that is the case, as I recall you have very limited options in Power BI and you generally go through Azure Streaming Analytics to do any kind of aggregation/calculations.