Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Need help - Data from live query and streamed data in same dashboard is possible in pbi

Our use case and the architecture we’re planning to use explained below. Please check and let us know if this is a good approach for our use case.   Use case: Consumption of real time streaming da...
Need Help
  • v-kathullac's avatar
    v-kathullac
    1 year ago

     

    Hi Anonymous ,

    Thank you for reaching out to Microsoft Fabric Community Forum.

     

    can you please find the below points :

     

    • You can combine visuals from both streamed and live/DirectQuery datasets on a single Power BI dashboard.

    • Visuals must be created in separate reports (one per dataset) and then pinned to the same dashboard manually.

    • No cross-filtering or interactivity between visuals from different datasets.

    • Streaming dataset visuals update in real-time.

    • Live/DirectQuery visuals refresh based on dashboard tile settings (default: every 15 minutes, can be reduced to 1 minute).

    • Cannot mix streaming and DirectQuery data sources in the same report or visual.

    • Dashboard serves as a view-only layer, combining outputs from different sources, not a unified data model.

    • For interactivity between visuals, consider combining both datasets into one model using Import or DirectQuery.

     

    Regards,

    Chaithanya.

     

v-kathullac's avatar
v-kathullac
Icon for Community Support rankCommunity Support
1 year ago

 

Hi Anonymous ,

Thank you for reaching out to Microsoft Fabric Community Forum.

 

can you please find the below points :

 

  • You can combine visuals from both streamed and live/DirectQuery datasets on a single Power BI dashboard.

  • Visuals must be created in separate reports (one per dataset) and then pinned to the same dashboard manually.

  • No cross-filtering or interactivity between visuals from different datasets.

  • Streaming dataset visuals update in real-time.

  • Live/DirectQuery visuals refresh based on dashboard tile settings (default: every 15 minutes, can be reduced to 1 minute).

  • Cannot mix streaming and DirectQuery data sources in the same report or visual.

  • Dashboard serves as a view-only layer, combining outputs from different sources, not a unified data model.

  • For interactivity between visuals, consider combining both datasets into one model using Import or DirectQuery.

 

Regards,

Chaithanya.