Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Error loading data in column in Power Query

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 appreci...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

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.