Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Scheduled Refresh Error with Snowflake

Hello, 

 

I just recently setup my snowflake dataset in my workspace and during it's scheduled refresh I received the following error. What would be the reason for the "native queries are not supported" message? My snowflake query works in both PowerBi desktop and in my snowflake environment so there is nothing wrong with the query itself. Any suggestions?

 

 

 

Need Help
  • edhans's avatar
    edhans
    4 years ago

    You've added something to the advanced SQl section in the connection of the query. I would avoid that. Either add that SQL code to snowlake itself directly and then access the view in Power BI, or get rid of it and redo the code using Power Query. It will fold the steps back.

1 Reply

  • edhans's avatar
    edhans
    Community Champion
    4 years ago

    You've added something to the advanced SQl section in the connection of the query. I would avoid that. Either add that SQL code to snowlake itself directly and then access the view in Power BI, or get rid of it and redo the code using Power Query. It will fold the steps back.