Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Power Query import show many col as null

Not sure what is going on here.  I am importing the contents of a folder.  There are 4 files.  All are formatted the same, etc.  One file has many columns importing all as null, but other columns are correct.  The other 3 files all import correctly.  If I create a separate PBI file with just the one file it works as expected.  What am I missing here?

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi Sam,

 

I am on the latest version.  I figured it out.  The column headers were slightly different.  Some had spaces between words and the other had underscores.  I knew it would be someing simple.

 

Thanks for the response.

Brian

View solution in original post

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

The latest version of Power BI Desktop seems to work for me. You may also check The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi Sam,

 

I am on the latest version.  I figured it out.  The column headers were slightly different.  Some had spaces between words and the other had underscores.  I knew it would be someing simple.

 

Thanks for the response.

Brian

Anonymous
Not applicable

Capture1.JPGCapture2.JPG

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.