Data table is empty

[Dave_Parkes]

So, I am very new to Power BI and i'm sure there is an easy answer but....

I have 3 tables, Date, Customer info and quote data. All come from Excel, the first 2 show all the data they should in PBI. The third ahows no data, but if i go to the column headers all the data is there in the listed filters so it is accessing the right data. From this point i cannot then go to make the relationships i need to to progress.

I'm sure i'm doing something simple incorrectly but i'm stuck. 

[v-shex-msft · Accepted solution]

HI @Dave_Parkes,

It seems like power bi recognizes lots of blank rows as table records so you can only view the blank records. I'd like to suggest you use 'remove blank row' function in the query editor to remove these blank rows.

How to delete blank rows in Excel using Power Query 
Regards,

Xiaoxin Sheng

[amitchandak]

@Dave_Parkes , click on some other table in the data view. Come back and click on one of the fields in this table data view. In the fields list pane at the right side and check

[Dave_Parkes]

The solution was to delete blank rows

[Dave_Parkes]

No success I'm afraid

Can i send a PDF of screen shots to illustrate the problem?

[Greg_Deckler]

@Dave_Parkes Can you share some screen shots. I have noticed in Data view that sometimes when you click on a table, nothing shows up but if you click on a column within the table over in the Fields area, everything shows up. Might be that perhaps?

[Dave_Parkes]

I tried as suggested but no successData table is empty but the data is present as it is shown in the filters

[az38]

@Dave_Parkes 

hi, I see a lot of blank values here and (blank) value in the filter list. try to check filter out (blank)