Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

Assistance for setting up real time dashboard

Hi dear community members!, need some guidance on how to achieve real time data visuals using Rest API call. As of now I tried using streaming data model in PowerBi service, which have limited visuals and I want to use all DAX features, slicers and differnet charts as well. I tried linking the streaming data model source to PowerBI desktop version, want to know whether there is a way to create table with the incoming data using this approach so that can create measures, slicers etc. My end goal is to have Both Live monitoring and ability to use DAX features, slicers and differnet charts. 

 

Thank You ğŸ˜Š.

  • Anonymous's avatar
    Anonymous
    8 months ago

    Dear sir,

    Thank you for your prompt response and valuable suggestion. I will proceed with this approach and am hopeful that it will help resolve the issue and achieve the intended outcome.

7 Replies

  • Anonymous  

    welcome to this Fabric community forum.

     

    Thinking out-of-the-box, have you considered the Fabric Real-Time Intelligence items like the Real-Time dashboard? If you can move/duplicate the data (stream) to the Eventhouse, you can add a Real-Time dashboard on top of it.

     

    As another alternative, you can use PowerBI DirectQuery to visualize Eventhouse data via a semantic model:

    • Data stays in Eventhouse (no import into Power BI).
    • Queries are executed live against Eventhouse using KQL.
    • Dashboards always show real-time or near real-time data.

    -- 

    If this answer helps you, a thumbs-up or marking it as accepted answer is appreaciated.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Dear sir,

      Thank you for your prompt response and valuable suggestion. I will proceed with this approach and am hopeful that it will help resolve the issue and achieve the intended outcome.

      • v-saisrao-msft's avatar
        v-saisrao-msft
        Community Support

        Hi Anonymous,

        Have you had a chance to try the solution suggested by svelde and checking whether the issue has been resolved?

         

        Thank you.

  • Hi Anonymous,

    Streaming semantic models are designed for low-latency dashboard tiles only and do not support tables, DAX measures, slicers, relationships, or full report creation in Power BI Desktop. Since they lack a database, they are not suitable for comprehensive reporting. For near real-time data with full reporting features, use a push (or push streaming) semantic model through the Power BI REST API. Push datasets store data in tables, making DAX, slicers, and all standard visuals available in both the service and Power BI Desktop. This allows you to pin report visuals to dashboards for near real-time updates.

    Real-time streaming in Power BI - Power BI | Microsoft Learn

    Push Datasets - Datasets PostDataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn

    Power BI REST APIs push semantic model limitations - Power BI | Microsoft Learn

     

    Thank you😊. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for your revert, I have been using the same push REST API call, the only thing that I am concerned about is that even with this approach I cannot pin my slicers on the dashboard to switch between plots or highlight certain data. So, as a workaround I created a button to switch from dashbaord to report. 

  • Thank you for this detailed discussion.
    I am a student and new to Microsoft Fabric and Power BI.
    This thread helped me understand the limitations of streaming datasets
    and the difference between dashboards and reports in real-time scenarios.
    Really appreciate the insights shared here.

  • Hi Anonymous,

    Checking in to see if your issue has been resolved. let us know if you still need any assistance.

     

    Thank you.