Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
pborah
Post Prodigy
Post Prodigy

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.

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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?

Yes that is correct!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors