topic Re: Syntax to import Snowflake table into Excel's PowerQuery Editor in Data Warehouse

Syntax to import Snowflake table into Excel's PowerQuery Editor

Diana2022 — Wed, 19 Feb 2025 15:48:55 GMT

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

Re: Syntax to import Snowflake table into Excel's PowerQuery Editor

nilendraFabric — Wed, 19 Feb 2025 19:10:41 GMT

Hello Diana2022

Try

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

Re: Syntax to import Snowflake table into Excel's PowerQuery Editor

Anonymous — Mon, 24 Feb 2025 12:56:45 GMT

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

Re: Syntax to import Snowflake table into Excel's PowerQuery Editor

Anonymous — Mon, 09 Jun 2025 05:16:15 GMT

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