data from snowflake, update per hour

[reynold522]

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!

[ibarrau · Accepted solution]

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,

[reynold522]

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!