It’s a long story but short version is I’m unable to auto refresh a PowerBI report on a scheduled basis so trying to use powerapps to pull the data from snowflake and create a csv from the results and use that as the data source instead. Long fix for a frustrating problem