Data not Visible

[DK92886]

Hi there,

I have imported an Excel table and I can only see my data in Edit Query.  When I close and apply from there, the data table is still not visible.  

I'm sure this is something simple.  I have deleted the data and imported again, reinstalled Power BI Desktop, and cursed.  None of those things have worked.  Thanks!!

TableEdit

[DK92886]

Using 32-bit to match our Office, if that matters.

[Greg_Deckler]

Nope, that's weird alright. Can't say I have seen that one. I use 64-bit version. Does the same thing happen if you save your Excel table to a CSV and then try to import that?

[DK92886]

Same thing. I have been playing with this file for a bit, and I am pretty sure that I imported it once before and all was fine.  I updated Power BI yesterday, that is the only thing I can think of.  I will try installing the older version (January, I think) and see if that works.  I only get to "play" with this when I have extra time, so it can be hard to tell when an error occurs.

[Greg_Deckler]

I updated mine today to April release and I have been able to import and everything works fine, but I'm on the 64-bit version.

[DK92886]

It must have been something with that particular file.  It was 35MB, so I split it into different files and all is good.