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)
BECOME A BIG DATA ENGINEER IN 3 MONTHS with less than $100 investment
INTRO: Below is my guide to becoming a data engineer based on the current job market (08/08/2020) demands. I have outlined the TOP 5 foun...
-
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...
-
Scenario: I want to load data from a SQL Server table that has 1.7billion rows containing a column with data type varchar(max) which is popu...
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