We have a requirement to create PowerBI Dashboards from Azure Data Lake Store (ADLS Gen2) csv files.
However, when importing data in PowerBI some columns were misaligned because PowerBI was parsing double-quote characters are field delimiters inappropriately.
Solution
In your ETL replace all double quote characters to two single quote characters.
Subscribe to:
Post Comments (Atom)
-
1. Good Foundational Knowledge of SQL Programming (SQL Query writing) Paid Course The best SQL course that I know. (I have not affili...
-
Hi I was recently working on extracting a table that has 400 columns from a SQL Server DB to load into an Oracle Target Database. I design...
-
In this blog post I will show you how to implement your own custom logging in Azure Data Factory Before you do this please note that Azur...
Thank you for sharing this Informative blog, it is very useful.
ReplyDeleteData Engineering Services
Exceptional entry! I found it very interesting. I'll check back later to see if more posts are added. data science from scratch
ReplyDelete