Forum Discussion
data from snowflake, update per hour
Hi all,
I have several IoT devices and send data in snowflake.
the table updated once per hour in snowflake.
I builded some measures and use them in visual of power bi.
I used direct query to get data from snowflake
I have to wait a long time to see my visual in power bi.
Is it possible to have a pre-calculated visual so that it only update once per day(not so optimal, however, I can also accept same frequency with once per hour). then the value and graph will be there for the whole day (or one hour)?
Thanks in advance!
Hi. DirectQuery has many tricks to make it work fast. There are some considerations, you can read those here:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directqueryIf you want asyncronous refreshes to make the report perform faster for the user, you can create a new Power Bi Desktop file and connect with "Import mode" to snowflake. That will let you schedule refreshes. It depends on the licence you have if you can refresh 8 times a day (pro) or if you can refresh 48 times a day (premium).
When I have read IoT I was thinking that you might want to consider streaming approaches. Just in case you have to show right now kpi numbers.
I hope that helps,
2 Replies
Hi. DirectQuery has many tricks to make it work fast. There are some considerations, you can read those here:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directqueryIf you want asyncronous refreshes to make the report perform faster for the user, you can create a new Power Bi Desktop file and connect with "Import mode" to snowflake. That will let you schedule refreshes. It depends on the licence you have if you can refresh 8 times a day (pro) or if you can refresh 48 times a day (premium).
When I have read IoT I was thinking that you might want to consider streaming approaches. Just in case you have to show right now kpi numbers.
I hope that helps,
Thank you! import mode is not good form me. However, I will try to look at streaming approaches. might be a alternative for me.
your answer is accepted as solution!
