- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Error when getting data using SQL statement from Snowflake?
I'm trying to bring data into my Power BI model from Snowflake using a SQL statement. I've entered the Server, Warehouse, and Database along with the SQL statement, but it keeps returning the error message below.
This is the SQL statement.
select os.*,oa.* FROM PRODUCTION.MARKETING.DIMENSONS_ORDERSSUMMARY OS
inner join PRODUCTION.MASTER_DIMENSIONS.DIMENSIONS_ORDERAPPOINTMENTS oa on oa.order_id=os.fk_order_id and oa.location_type=os.location where os.FK_ORDER_ID is not null and oa.status_=1
Can anyone help me understand what is causing this?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @ERing ,
This is giving error while connecting. You are selecting everything from both the tables (os.* and oa.*) and most probably "Field ID " is present in both the table. I would suggest selecting required columns only with corresponding reference like oa.order_ID as Order_ID, os.location as Location etc.
I hope this helps .
Did I solve your problem, if yes please mark this as solution.
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ERing ,
Did divyed and danextian suggestions solve your confusion, and if the problem has been solved, you can mark the standard answer in your reply to help other members find the answer faster. If not, please point it out.
Best Regards,
Neeko Tang
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @ERing ,
This is giving error while connecting. You are selecting everything from both the tables (os.* and oa.*) and most probably "Field ID " is present in both the table. I would suggest selecting required columns only with corresponding reference like oa.order_ID as Order_ID, os.location as Location etc.
I hope this helps .
Did I solve your problem, if yes please mark this as solution.
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That is normally the error if you're trying to create a column which name already exists? Are you building the query in the query editor from scratch or just editing the source applied step?
Dane Belarmino | Microsoft MVP | Proud to be a Super User!
Did I answer your question? Mark my post as a solution!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am using the "Get Data" option.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What I meant was is that an existing query and you're simply editing the connection or a totally new one without additional steps other than the source and navigation?
Dane Belarmino | Microsoft MVP | Proud to be a Super User!
Did I answer your question? Mark my post as a solution!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-24-2024 05:26 AM | |||
05-12-2021 03:24 AM | |||
01-09-2023 03:59 AM | |||
01-15-2024 05:15 PM | |||
08-24-2023 08:40 AM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |