cannont expand table which is in column, where most columns are empty

[Anonymous]

I connect to share point list, in order to get version data, I invoked a custom function, Im able to get the virsion and most of the source data

when I tried to expand table form cloumn, where those colums which have "table" as record are empty at source file , how evere there is some data. 

problem is i could not expand some of them speacially those who have "Date" as data

 
here one is complete empty column, 
one has some data with in "table"
Third has some records with data ,most empty 

Please Help me 

[Anonymous]

Thanks for the Replay, 

I obtained Custom funtion :
 https://community.powerbi.com/t5/Desktop/Getting-SharePoint-List-items-with-full-history-version/td-...
to get version history data from share point 

i coneect to share point data, online list which is organisation, 
when i say blank, there is nothing entered in cell

[AllisonKennedy]

@Anonymous  Can you please provide more details about your custom function and source files? Do you have a sample of the 'empty' file so we can understand what you mean by 'almost empty' and how the Date column fits in.

[Anonymous]

I have a dataset published in sharepoint, created a share point list based on that Excel. 

with power Bi im connecting to SP-list, im able to build reports based on actual data.. But my client asked me to fetch all the data including share point "version history "
{   [ Version history ; Eg 1.0 , 2.0 , 3.0 ] updates done on any field is recorded with in version history which allow us to see past data aswell. } 
requirement is like I want to see all the data along with versions. which gives many records of duplicates... 
Client ;- when I choose past 1 month back i want to see only what is current values for that date ( latest version) 

My IDEA is pull version Table, Normal Table, Link Both and filter based on versions ? 
Another IDEA Pull all data in one Table as im now, slise data based on modified date ( share point modified date. ) Here how can I group data based on versions