Forum Discussion
Collation Error while reading data form SQL Endpoint of Lakehouse
We are trying to read data from Lakehouse using Stored procedure . Transform in SP and store it in warehouse . It was working fine when we had warehouse with collation type case sensitive . But getti...
You "only" need to cast the collation on the join column.
I would still consider this a bug. If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
Thank you for the response .
I will try for Join columns . Major issue I had is with reading data from Lake house and creating temp table or cte in warehouse for further usage of data in stored procedures .
Example below :
CREATE TABLE temp_01
AS
select * from LH_01.STG.table_01 where modified_date = <some date>
Result error :
NON DEFAULT COLUMN COLLATION is not supported for SELECT INTO.
Hi, I too facing the same issue now. Can anyone please provide solution ?
