import files .dat

Hi KHANOS123 

Power BI cannot directly read or import files with a .data extension.
To handle this we can convert .data files into  common format like CSV or Excel, which Power BI can handle.

Here's a step-by-step guide

1.Convet .data file to CSV, 
- Open the .data file in a text editor (like Notepad or any code editor).
- Save the file as a CSV (Comma-Separated Values) file. Ensure that the columns are separated by commas and each row is on a new line.

2.Import CSV File: 
-Use Power BI and import the CSV file.

3.Duplicate Columns in Power Query Editor:
-In the Power Query Editor, select the column you want to duplicate.
-Right-click on the column header and select "Duplicate Column".

4.Load Data:
-Once you've made the necessary changes, click "Close & Load" to load the data into Power BI

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.