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
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.
Solved! Go to 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.
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.
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.