403 Error when connecting Power BI dataflow to Snowflake DB

[paulmadison]

We are building a dataflow to pull Snowflake data into Power BI. When we refresh it runs for 6 hours and results in an error. How can I fix this?

Error: Data Source Error : DataSource.Error: ERROR [HY000] [Microsoft][Snowflake] (25) ;     Result download worker error: Worker error: [Microsoft][Snowflake] (4)

     REST request for URL https://sfc-va2-ds1-customer-stage.s3.amazonaws.com/xvmi-s-v2ss0959/results/01a770ab-0502-8972-0001-...  failed: HTTP error (http error) - code=403.

    . RootActivityId = 0e1ea62d-ee29-4c0a-84d5-2fae0c694c1b.Param1 = DataSource.Error: ERROR [HY000] [Microsoft][Snowflake] (25) 

     Result download worker error: Worker error: [Microsoft][Snowflake] (4) 

     REST request for URL https://sfc-va2-ds1-customer-stage.s3.amazonaws.com/xvmi-s-v2ss0959/results/01a770ab-0502-8972-0001-...  failed: HTTP error (http error) - code=403.

     Request ID: c73fd50c-3391-ffa5-8985-1043f643f9f6.

[v-yetao1-msft]

Hi @paulmadison 

If you connect to Snowflake DB in Power BI Desktop ,can you refresh the data successfully ? 

Best Regards,
Community Support Team _ Ailsa Tao

[paulmadison]

No, Power Bi Desktop gets a similar error.  I've narrowed it down to the snowflake auth token expiring before power bi can finish.  We will try it with a larger warehouse and see if that makes a difference.

[v-yetao1-msft]

Hi @paulmadison 

Can you connect Power BI dataflow to Snowflake DB successfully now ?

Best Regards,
Community Support Team _ Ailsa Tao

[paulmadison]

Yes, we were able to connect.  Our issue was that we had too many power query steps running on a large dataset.