undefined

[sumilagoz]

How to load NC4 file type in Power BI Desktop?

[Syndicate_Admin]

The newest tool is:

Open NC File

and

MODIS Products Extractor

[Syndicate_Admin]

The newest one is:

Open NC File

[freginier]

You can't you need to convert to a readable file like CSV

[sumilagoz]

Do you have any idea how to convert?

[v-yingjl · Accepted solution]

Hi @sumilagoz ,

To convert it to csv format, you can try that

For Windows user:

1. Convert it directly online: Convert NETCDF to CSV Online 
2. Download and install netcdf4excel.  The plug-in opens directly NetCDF files in Microsoft Excel maintaining conventions for the NetCDF variables. Please see the link for more details: http://netcdf4excel.github.io/.

For Linux user, refer this document in details: How to convert NetCDF to CSV 

The first option is to use a python script.The script allows you to covert data from NetCDF in two different ways, as explained in the workflow below:

• Retrieve data with the CDS API and store as a netCDF4 file in the working directory.
• Extract the variable from the NetCDF file and get the dimensions (i.e. time, latitudes and longitudes)
• Extract each time as a 2D pandas DataFrame and write it to the CSV file
• Write the  data as a table with 4 columns: time, latitude, longitude, value

A second option is to convert the data using the NASA 'Panoply' software. User can find the option under File → Export data → As CSV. The data are saved in the file maintaining the structure of the lot/lan matrix, but different times are divided by an empty row.

For Unix users, there are others options provided by some common NetCDF software packages. Please the links for more details:

• ncdump → http://manpages.ubuntu.com/manpages/xenial/man1/ncdump-hdf.1.html
• cdo → https://code.mpimet.mpg.de/projects/cdo/wiki/Tutorial
• ncks → https://www.unidata.ucar.edu/support/help/MailArchives/netcdf/msg08405.html

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

There are Python and R packages that can read it as well as tools like NetCDF Extractor.