Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Wrong encoding when reading from Azure Synapse View on top of Parquet files

Hi,    I have a view in Azure Synapse on top of my parquet files, I've created it like this: CREATE VIEW [dbo].[v_tmp] AS (      SELECT * FROM      OPENROWSET( BULK 'https://***.dfs.core.window...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Afterall I found the solution: you should indeed change the collation of the database using the query below. But I also needed to recreate the views on top. Probably something was cached. I have the correct encoded data in power BI now. 

    ALTER DATABASE datawarehouse 
        COLLATE Latin1_General_100_BIN2_UTF8;
     
    Thanks for all of your input!
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Afterall I found the solution: you should indeed change the collation of the database using the query below. But I also needed to recreate the views on top. Probably something was cached. I have the correct encoded data in power BI now. 

ALTER DATABASE datawarehouse 
    COLLATE Latin1_General_100_BIN2_UTF8;
 
Thanks for all of your input!