Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I have a view in Azure Synapse on top of my parquet files, I've created it like this:
Is there someone here with other ideas that I could try to overcome this issue?
Thanks a lot!
Solved! Go to Solution.
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.
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.
Hi @Anonymous ,
Would you please try to get data directly from 'https://***.dfs.core.windows.net/dwh/tmp/*.parquet instead of using view from Azure Synapse?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thanks for your answer!
This does indeed work, but it is not what I want because I would like to keep my Power BI clean and user the Serverless pools to connect to.
What happens when you use the query as your data source (rather than the view)?
Hi,
When I query directly on the parquet file from within powerBI the encoding goes correctly. So the error must be somewhere in Synapse then.
Any idea what I can test more?
Thanks a lot for your input!