Syntax to import Snowflake table into Excel's PowerQuery Editor

[Diana2022]

Hello,  I am brand new to Snowflake.  I'm coming from Oracle SQL.  

I have some example tables in Snowflake and I'm having trouble with syntax to import into Excel's  Power Query editor (I have successfully imported into Power BI's PowerQuery editor).   Its a small little table, so no size issues.  Guessing an addressing error of some sort?  I've included a snip of the folder heirarchy and one of the iterations I've tried. @DataInsights

 

[v-vpabbu]

Hi @Diana2022,

It appears this issue is related to Excel. If the solution provided by the super user did not resolve your problem, I request you to please raise it in the respective Excel community forum.

Excel | Microsoft Community Hub 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @Diana2022,

As we haven't heard back from you, I hope you have raised in Excel Community. At this time we are closing this thread. If you have any further issues, please start a new thread in the community forum, and we are here to assist you. Thankyou for your understanding and continuous support.

Thank you for being part of the Microsoft Fabric Community.

Regards,

Vinay Pabbu

[nilendraFabric]

Hello @Diana2022 

Try

SELECT * FROM [DATABASE_NAME].[SCHEMA_NAME].[TABLE_NAME]