Forum Discussion
Invalid Identifier
I'm loading data by connecting to Snowflake through an OBDC connector. Certain columns that load fine in the Snowflake web portal won't load into Power BI desktop, throwing this error:
DataSource.Error: ODBC: ERROR [42000] SQL compilation error: error line 8 at position 0
invalid identifier 'EVENT_UUID'
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=(mydsn);warehouse=(mywarehouse)
OdbcErrors=Table
This error occurs for 6 of my 50+ columns, and I can't find any rhyme or reason for it. If I remove those columns from my SQL query the rest of the table loads fine.
How can I resolve this issue so I can load my entire table?
My apologies - I was doing this late last night and in my tired state was referencing the wrong table.. no wonder I wasn't getting all the columns I expected!
Mods, please feel free to delete this post.
1 Reply
My apologies - I was doing this late last night and in my tired state was referencing the wrong table.. no wonder I wasn't getting all the columns I expected!
Mods, please feel free to delete this post.