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 p...
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.

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?

    • GilbertQ's avatar
      GilbertQ
      Super User
      2 years ago

      Yes that is correct!