Import of IP address xxx.xxx.xxx.xxx being imported as decimal number

[Warren Rosenbaum]

I have a csv that has ip addresses in a column in the following format. I am importing it into power pivot, using From other sources - Test file method
It is being imported as a decimal number, 10.1121.

How can i import it and leave it as an ip address?

timestamp,server,location,environment,application,instance,tier,entity_type,status,name,msg_type,os_type,ip_addr,cpu_count,cpu_percent_used(%),cpu_warn_threshold(%),cpu_err_threshold(%),mem_size,mem_percent_used(%),mem_warn_threshold(%),mem_err_threshold(%)
2023-01-26T13:22:00-0500,copuvlpoca01,co,Dev,ERT,,Application,server,success,copuvlpoca01,server,Linux,10.112.100.16,4,21.75,85,90,15955,15.99,50,75
2023-01-26T13:22:30-0500,copuvlpoca01,co,Dev,ERT,,Application,server,success,copuvlpoca01,server,Linux,10.112.100.16,4,22.67,85,90,15955,16.00,50,75
2023-01-26T13:23:00-0500,copuvlpoca01,co,Dev,ERT,,Application,server,success,copuvlpoca01,server,Linux,10.112.100.16,4,17.46,85,90,15955,15.99,50,75

 

[p45cal]

I am importing it into power pivot

How are you inporting it? What steps do you use?
If you can, attach a csv file, but, and this is vital, one that hasn't even been looked at by, or loaded into, Excel, ever.

 

[Warren Rosenbaum]

Here are 2 that have IP Addresses. These have not been previously imported. Thanks

 

[Warren Rosenbaum]

I go to power pivot, select from other sources. select text file, select the file and import

 

[p45cal]

When I tried to fetch data from within Power Pivot I got to this point, where I haven't yet checked the Use first row as column headers and the ip addresses are complete:



however as soon as I tick that box, the IP addresses go wrong:



I don't know why, however I went through Power Query instead:
In the data tab of Excel's ribbon, choose From Text/CSV:



choose your file and click Import



Then in the next dialogue choose Load to from the Load button:



continued in next message (only 5 pics allowed)

 

[p45cal]

…then in the next dialogue, ensure Add this data to the data model is checked and Only create connection:



click OK. You then have a new query in Excel's Queries & Connections and you can go into Manage Data Model:



where the IP addresses are complete:



Now you have headers and complete ip addresses.

At an earlier stage, if you'd chosen to Transform Data instead of Load to…



you'd have been able to add/alter/remove Applied Steps which Power Query added automatically, before Loading to…:

 

[Warren Rosenbaum]

I did the import and it creates a tab in the spreadsheet. I wanted all the input data, which includes multiple text files to be in Power Pivot, which provides me additional capability.

 

[Warren Rosenbaum]

plz ignore my previous response. It works as I need it to. Thank you