Can streaming models using push be preprocessed before visualizing?

[pborah]

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.

[GilbertQ · Accepted solution]

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]

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]

Yes that is correct!