Unable to setup scheduled refresh on imported data from Snowflake?

[Anonymous]

Hi,

I have multiple tables imported from Snowflake DB and few coming in from DataLake Gen1 storage.

When I publish the report to the PBI service the Scheduled refresh is disabled not sure why? 

Could somebody let me know how to fix this?

I've also tried the DirectQuery method but even that throws error " This query contains transformations that can't be used for DirectQuery." not sure what that error means as well. 

thanks

[v-jingzhang]

Hi @Anonymous 

Are you using a gateway? What is the behavior on service when you say "the Scheduled refresh is disabled"? Is there any detailed error information?

You may find the following link helpful:

Announcing enhanced connectivity for Snowflake | Microsoft Power BI Blog | Microsoft Power BI

Best Regards,
Community Support Team _ Jing Zhang

[Anonymous · Accepted solution]

I dont think Gateway is needed for Snowflake connector, Snowflake Connector allows data refresh via Import method if the credentials are enabled. That being said I was stupid enough to not check other datasources apparently one of the other datasource is the report was from local drive which was stopping from enabling datarefresh.

Thank you for your respons.

[amitchandak]

@Anonymous , Have you setup the gateway?https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

https://radacad.com/the-power-bi-gateway-all-you-need-to-know
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem