Using gateway to refresh a Dataset in PBI Services having Snowflake as source

[IlikePBI]

Hello,

We are encountering an issue with refreshing our dataset in Power BI Services due to the large size of the fact table (1.2 billion rows). The error message states: "The refresh operation failed because it took too long to complete. Consider reducing the size of your dataset or breaking it up into smaller datasets." We are using Snowflake as our data source and currently do not have a gateway configured. I am seeking information on whether using a gateway could help in the refresh, and if so, what type of gateway would be most appropriate for our needs.

Thank you for your help.

[djurecicK2]

Hi @IlikePBI ,

 This article might be useful to you:

https://www.bluegranite.com/blog/creating-efficient-power-bi-datasets-over-snowflake

[IlikePBI]

Hi @djurecicK2 ,

Thank you for your answer. We have already Premium Capacity P2.

[djurecicK2]

Hi @IlikePBI ,

 Not sure if a gateway would help. What Power BI license do you have? If feasible, I would look at Premium Per User or Premium capacity if you don't already have it.