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.

     

burakkaragoz's avatar
burakkaragoz
Icon for Super User rankSuper User
1 year ago

Hi Anonymous ,

 

We’ve done something similar with Kafka + Power BI. Your setup looks solid for now – Kafka consumer pushing to a Push Dataset works fine for real-time visuals.

Just a heads-up though: streaming datasets are being retired in 2027, so long-term you’ll need to move to Real-Time Intelligence in Fabric.

Couple notes:

  • Push Datasets can’t be combined with DirectQuery in the same model, so mixing live query + stream in one dashboard is tricky.
  • One workaround is to land the Kafka data into a lakehouse or warehouse table and use that in a composite model.

If you’re on Premium, you’ll likely get Fabric access soon anyway – might be worth testing RTI early.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    We can get the fabric within this quarter.

    I’d like to know:
    • Is it possible to combine visuals from both datasets (streamed + live query) in a single Power BI dashboard?
    • If yes, are there any limitations I should be aware of (e.g., refresh behavior, interactivity)?