Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm trying to work around and find the solution how to bring relevant data to pbi from Snowflake DB.
I have a connection to Snowflake DB, but it is huge and I can't load it all, to reduce size I need to use SQL query to inner join two tables and filter it.
When I connect to Snowflake I add SQL in this box:
However it gives me this error:
Is there a way I can have dynamic connection to Snowflake Database with SQL query?
TIA
Solved! Go to Solution.
Try removing the semicolon at the end of the SQL. Also, try removing the quotes from the database, schema, and table names.
Proud to be a Super User!
@Anonymous,
Custom SQL requires that you populate the Database field:
Proud to be a Super User!
When I typed in this box "LIGHCAST"."UK""POSTING_SKILLS" it gives me the same error.
Enter only the database name LIGHTCAST.
Proud to be a Super User!
Thank you fro your answer, now it gives this error
Try removing the semicolon at the end of the SQL. Also, try removing the quotes from the database, schema, and table names.
Proud to be a Super User!
I'm having this same issue, but I didn't have the table names in "" and no semicolon in my sql. I've noticed that if a hard code the connection into the query editor I have no issue pulling in my data - but this is a bit of a faff. I've tested with a very simple sql expression:
select count(*) from [warehouse].[schema].[table] but literally any sql in the UI will cause this error for me.
Like I say, I have a viable workaround but would like to know what's causing this issue in case I need to trouble shoot again in the future.
Thank you so much, it works!