Forum Discussion

aj1973's avatar
aj1973
Community Champion
1 year ago
Solved

Data flow Gen 1 to Snowflake

Hi community, This morning my Dataflows Gen 1 have stopped refreshing from Snowflake. I tried to connect a new Dataflow to Snowflake and to a PostgreSQL and the result was the same. Is any body havi...
Dataflow
  • v-veshwara-msft's avatar
    v-veshwara-msft
    1 year ago

    Hi aj1973 ,

    Thank you for sharing your experience regarding the connectivity issues with Dataflows Gen 1 to Snowflake.

    This was a known issue that has since been resolved by Microsoft. Thanks for confirming that the issue has been resolved on your end.

    klinejordan , john112 , could you kindly confirm if the issue has been resolved for you as well?
    If you are still encountering problems with Dataflows Gen 1 and Gen 2, please try the following steps:

    1. Update Data Source Credentials: Re-authenticating the connection by updating your data source credentials can sometimes resolve lingering issues.
    2. Create a New Dataflow: Try setting up a new Dataflow connected to Snowflake to see if the issue persists. This can help determine if the problem is specific to the existing Dataflow.

    If the issue remains unresolved after following these steps, we recommend raising a support ticket with Microsoft for further investigation.
    Please follow this guide to create a support ticket:https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket 

    Thank you again for your patience, and please let us know how things progress.

    If this post helps, then please mark it as the solution to help the other members find it more quickly.

    Best regards,
    Vinay.

john112's avatar
john112
New Member
1 year ago

Hi v-veshwara-msft, this issue is solved for me. However, in my semantic model, I'm getting a new error:


Data source error: Resource Governing: This operation was canceled because there wasn't enough memory to finish running it. Either reduce the memory footprint of your dataset by doing things such as limiting the amount of imported data, or if using Power BI Premium, increase the memory of the Premium capacity where this dataset is hosted. More details: consumed memory 22508 MB, memory limit 22101 MB, database size before command execution 3498 MB. See https://go.microsoft.com/fwlink/?linkid=2159753 to learn more.

 
I have never gotten this error before. I deleted some tables from our model, with no changes, though not much more memory could have be used vs. the prior refresh, beyond a few additional hours of data. Were there other Power BI changes made that would cause this error?
v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi john112 ,

Thank you for sharing the details about the resource governing error you're encountering in your semantic model.

Since this issue is unrelated to the original topic of this discussion, we kindly suggest creating a new post in the forum. This will help the community and experts focus specifically on your concern and provide the best possible assistance.

We appreciate your understanding and look forward to supporting you further in your new post!

Best regards,
Vinay Kumar.