Forum Discussion

pborah's avatar
pborah
Solution Sage
2 years ago
Solved

Can streaming models using push be preprocessed before visualizing?

I have a dataset in our SQL data warehouse that updates every 15 minutes. But it's more granular than what I need it for. So I was wondering if I can summarize it at the 15 minute interval level on power bi side before adding a tile?  Or would it be better to do that on the warehouse side? Thanks.

Need Help
Show and Tell
Tips and Tricks
  • GilbertQ's avatar
    GilbertQ
    2 years ago

    Hi pborah 

     

    What you could do is to change your sequel query from your data warehouse to go in 15 minute buckets, which could then import into your power BI model and then refresh your power be our model every 15 minutes.

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi pborah 

     

    What you could do is to change your sequel query from your data warehouse to go in 15 minute buckets, which could then import into your power BI model and then refresh your power be our model every 15 minutes.

    • pborah's avatar
      pborah
      Solution Sage
      2 years ago

      Thank you GilbertQ , if I understood you correctly, you are advising to preprocess/summarize the granular data in 15 minute intervals and then push to power bi service?