Import from CSV in Power BI | Fixing missing decimals and columns
How to Power BI2021-03-19
csv power bi#import csv power bi#power bi csv#power bi import csv#import csv in power bi#csv in power bi#missing decimals power bi#missing columns power bi#power bi missing decimals#csv file in power bi#power bi csv data source#importar csv power bi#power bi csv file#power bi csv decimal separator#power bi#power bi tutorials for beginners#power bi desktop
16K views|3 years ago
💫 Short Summary
The video discusses how to fix two common problems when importing data from CSV files into Power BI: the disappearance of decimals and the issue of columns not showing up. It demonstrates the solutions by adjusting regional settings and data types to ensure the correct interpretation of decimal separators, and by removing optional arguments to allow new columns to appear after data refresh.
✨ Highlights
📊 Transcript
✦
The video discusses two common problems when importing data from CSV files into Power BI: decimals disappearing and new columns not showing up.
00:00Two CSV files with different decimal and thousand separators are shown.
The issue with decimals disappearing is due to regional settings, and the solution is to change the regional settings for the whole workbook.
To handle different decimal separators within the same Power BI file, the video demonstrates using a specific locale for the data type.
A dynamic approach to handling unknown decimal separators in CSV files is also presented using Power Query language.
✦
The video demonstrates how to change regional settings in Power BI to handle different decimal separators in CSV files.
03:02Go to File > Options > Options
Select Regional Settings under Current file and choose a different region that uses the desired decimal separator.
The video also shows the use of a specific locale for data type assignment to handle different decimal separators within the same Power BI file.
✦
A new column is added to a CSV file, and the issue of it not showing up in Power BI is resolved by removing an optional argument in the source step.
06:01The formula in the source step contains an optional argument that defines the number of columns.
By removing this optional argument, the new column appears after refreshing the data in Power BI.
✦
The video demonstrates how to fix data type and new column issues when combining data from CSV files in a folder in Power BI.
08:09Fixing the data type issue by selecting the sales column and choosing to assign a data type with a specific locale.
Removing the optional argument 'columns equals two' from the formulas for transform file and sample file to ensure new columns flow into Power BI.
The video encourages viewers to share any other problems they have when connecting to CSV files and emphasizes subscribing for more content.
💫 FAQs about This YouTube Video
1. How can the issue of disappearing decimals when importing CSV files into Power BI be fixed?
The issue of disappearing decimals when importing CSV files into Power BI can be fixed by adjusting the regional settings in Power BI to match the format of the CSV files. This ensures that the correct decimal and thousand separators are used, preventing the values from being interpreted incorrectly. Additionally, specific locales can be specified for data types to handle different decimal separators within the same Power BI file.
2. What can be done if columns added to a CSV file do not show up in Power BI after refreshing?
If columns added to a CSV file do not show up in Power BI after refreshing, the issue can be resolved by ensuring the number of columns argument is optional or by adjusting the settings in Power BI to accommodate the changes in the CSV file. By making the necessary adjustments, the new columns should appear correctly in Power BI.
3. How can the mismatch of decimal separators between CSV files and Power BI be addressed?
The mismatch of decimal separators between CSV files and Power BI can be addressed by carefully managing the regional settings and specifying the appropriate locales for data types. This ensures that the decimal separators are correctly interpreted, preventing errors and discrepancies in the data.
4. What is the solution for handling new columns that are not showing up in Power BI when connected to a folder of CSV files?
The solution for handling new columns that are not showing up in Power BI when connected to a folder of CSV files involves ensuring that the column argument is optional and making adjustments in Power BI to properly incorporate the new columns. By following these steps, the new columns should be successfully integrated into Power BI.
🎥 Related Videos![What vaccinating vampire bats can teach us about pandemics | Daniel Streicker](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FlSPxeA6Z_m4%2Fhqdefault.jpg&w=3840&q=75)
![a16z Podcast | Things Come Together -- Truths about Tech in Africa](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fjbl5I7kYWHM%2Fhqdefault.jpg&w=3840&q=75)
![2024 TSCRS Applications of anterior segments diagnostic instruments in cataract surgery](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FWnUDk5vKuqE%2Fhqdefault.jpg&w=3840&q=75)
![a16z Podcast | The Infrastructure of Total Health](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FoLGRslHa5FE%2Fhqdefault.jpg&w=3840&q=75)
![The Robot Lawyer Resistance with Joshua Browder of DoNotPay](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FAmVdYPTdw2c%2Fhqdefault.jpg&w=3840&q=75)
![NES Controllers Explained](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FnAStgQzPrAQ%2Fhqdefault.jpg&w=3840&q=75)
![What vaccinating vampire bats can teach us about pandemics | Daniel Streicker](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FlSPxeA6Z_m4%2Fhqdefault.jpg&w=3840&q=75)
What vaccinating vampire bats can teach us about pandemics | Daniel Streicker
![a16z Podcast | Things Come Together -- Truths about Tech in Africa](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fjbl5I7kYWHM%2Fhqdefault.jpg&w=3840&q=75)
a16z Podcast | Things Come Together -- Truths about Tech in Africa
![2024 TSCRS Applications of anterior segments diagnostic instruments in cataract surgery](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FWnUDk5vKuqE%2Fhqdefault.jpg&w=3840&q=75)
2024 TSCRS Applications of anterior segments diagnostic instruments in cataract surgery
![a16z Podcast | The Infrastructure of Total Health](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FoLGRslHa5FE%2Fhqdefault.jpg&w=3840&q=75)
a16z Podcast | The Infrastructure of Total Health
![The Robot Lawyer Resistance with Joshua Browder of DoNotPay](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FAmVdYPTdw2c%2Fhqdefault.jpg&w=3840&q=75)
The Robot Lawyer Resistance with Joshua Browder of DoNotPay
![NES Controllers Explained](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FnAStgQzPrAQ%2Fhqdefault.jpg&w=3840&q=75)
NES Controllers Explained
🔥 Recently Summarized Examples![The Hitler-Stalin Pact | Reflections Episode 9](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FFiCmS9niS2U%2Fhqdefault.jpg&w=3840&q=75)
![Uncovering Corruption From Health "Experts" | Scott Carney](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FJP76ekb_DxI%2Fhqdefault.jpg&w=3840&q=75)
![The Forgotten Geometry: A New Path to Unification](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FTTSeqsCgxj8%2Fhqdefault.jpg&w=3840&q=75)
![Joe Rogan Experience #2194 - Luis Elizondo](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2F9gLPtRwXgCM%2Fhqdefault.jpg&w=3840&q=75)
![From Tesla to DNA: The Science of Scalar Waves - Dr. Sandra Rose Michael - Think Tank E44](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FzPxOsOsbNo8%2Fhqdefault.jpg&w=3840&q=75)
![Bitcoin Holders...Watch Out for Sept](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FNedUS9J4Er0%2Fhqdefault.jpg&w=3840&q=75)
![The Hitler-Stalin Pact | Reflections Episode 9](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FFiCmS9niS2U%2Fhqdefault.jpg&w=3840&q=75)
The Hitler-Stalin Pact | Reflections Episode 9
![Uncovering Corruption From Health "Experts" | Scott Carney](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FJP76ekb_DxI%2Fhqdefault.jpg&w=3840&q=75)
Uncovering Corruption From Health "Experts" | Scott Carney
![The Forgotten Geometry: A New Path to Unification](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FTTSeqsCgxj8%2Fhqdefault.jpg&w=3840&q=75)
The Forgotten Geometry: A New Path to Unification
![Joe Rogan Experience #2194 - Luis Elizondo](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2F9gLPtRwXgCM%2Fhqdefault.jpg&w=3840&q=75)
Joe Rogan Experience #2194 - Luis Elizondo
![From Tesla to DNA: The Science of Scalar Waves - Dr. Sandra Rose Michael - Think Tank E44](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FzPxOsOsbNo8%2Fhqdefault.jpg&w=3840&q=75)
From Tesla to DNA: The Science of Scalar Waves - Dr. Sandra Rose Michael - Think Tank E44
![Bitcoin Holders...Watch Out for Sept](/_next/image?url=https%3A%2F%2Fi.ytimg.com%2Fvi%2FNedUS9J4Er0%2Fhqdefault.jpg&w=3840&q=75)