Forum Discussion
Solved
OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42601] SQL compilation error: ambiguous column
I am using DirectQuery with Snowflake and for one of my visuals I am getting this error. It seems as though this is a bug with Power BI where it is not generating the SQL correctly. When I looked at ...
In this case the best (and preferred option) in my opition is to create a view in snowflake.
Inside the view rename the field. The connect PowerBi to View instead of Table
Do not rename the field directly in the table. I wouldnt recommend that
I wanted to share to anyone else who views this thread that I got rid of the error message by changing the relationship between two tables in the model view. Once I checked "Assume referential integrity," I no longer got the error. Checking this box uses an INNER JOIN instead of an OUTER JOIN.