Forum Discussion
data from snowflake, update per hour
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,
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-directquery
If 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!