Forum Discussion
Data table is empty
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.
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
7 Replies
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
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?
I tried as suggested but no successData table is empty but the data is present as it is shown in the filters
hi, I see a lot of blank values here and (blank) value in the filter list. try to check filter out (blank)
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
No success I'm afraid
Can i send a PDF of screen shots to illustrate the problem?
The solution was to delete blank rows
