Error loading data in column in Power Query

[Anonymous]

I am trying to LOAD MORE in one of my columns in Power Query. but it says 200 ROWS LOADED. but it does not show me the rows.

here is a snap shot

what could be the problem?

I appreciate your help.

regards 

[v-lid-msft]

Hi @Anonymous ,

Based on my test, even load column contain all null value can see null in Filter,I cannot reproduce it,Could you please provide more details about it if your answer don't have any Confidential Information?

Can you see any data in the model view after refresh? What the type of data source you are connecting with? What the version of your Power BI Desktop?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I have version 2.73 of pBI. this is the latest.

data source is MS SQL db. i imported the tables.

if i referesh the problem stays the same. first you will see the data, it says load more, but if you click load more it will give you the issue (ie the image in my post)

the dataset is large, how can i share with you. its confidential but i can alter info for you. and upload it. the file size is .7 G

[v-lid-msft]

Hi @Anonymous ,

Sorry for that, But we still can not reproduce it under a 0.7G table, We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lid-msft]

Hi @Anonymous ,

It is dangerous and unnecessary to share data within public forum, so please do not share your data, we will test this condition and try to reproduce your issue.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.