Use PBI for massive flat files from NVSS

[amjenkens]

Does anyone have experience with using National Vital Statistics data in Power BI. I'm particularly interested in the birth data https://www.cdc.gov/nchs/data_access/vitalstatsonline.htm and curious how you went about making this a usable dataset through Power BI. Any help appreciated

[danextian]

I didnt have a problem importing about 4G of data into the model although that could be different if you had more plus extra transformations in PQ.

[v-cgao-msft]

Hi @amjenkens ,

You can import data by using the Text/csv connector.

Edit data in PowerQuery Editor.

Power BI Tutorial | From Flat File To Data Model - Guy in a Cube

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[amjenkens]

I understand how to use the get data, the problem is the file that indicates the delimeters and column values is in a separate file. How do I go about integrating the codebook file before loading the flat file so that it is specified correctly?

[danextian]

Can you share with us the other file?

[amjenkens]

https://www.nber.org/research/data/vital-statistics-natality-birth-data