This error has started happening with any changes being made to the files.
We are connecting to Snowflake from PBI service using basic credentials. Here is the error:
- Data source errorDataSource.Error: <pii>ODBC: ERROR [42000] SQL compilation error: error line 111 at position 31 invalid identifier 'OTBL.ENDO'</pii>. DataSourceKind = <pii>Snowflake</pii>. DataSourcePath = <pii>url.com;server</pii>. OdbcErrors = <pii>#table({"SQLState", "NativeError", "Message"}, {})</pii>. ;ODBC: ERROR [42000] SQL compilation error: error line 111 at position 31 invalid identifier 'OTBL.COLUMN1'. The exception was raised by the IDbCommand interface. Table: TABLE1.
PBI service creates an SQL script in Snowflake which looks like the below. The same is not created on PBI Desktop. Any ideas, please?
select
"COLUMN1",
"COLUMN2"
from
(
select
"COLUMN1",
"COLUMN2",
"C2",
case
when "ITBL"."C2" = "OTBL"."COLUMN1"
then ?
else ?
end as "C1"
from
(
select "OTBL"."COLUMN1",
"OTBL"."COLUMN2"
"ITBL"."C1" as "C2"
from "DATABASE"."SCHEMA"."TABLE2" as "OTBL"
left outer join
(
select "POLICY_NUM",
max("COLUMN1") as "C1"
from "DATABASE"."SCHEMA"."TABLE1"
group by "COLUMN2"
) as "ITBL" on ("OTBL"."COLUMN2" = "ITBL"."COLUMN2")
) as "ITBL"
) as "ITBL"
where "C1" = ?
