Go Summarize

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:00
Two 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:02
Go 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:01
The 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:09
Fixing 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.