PowerBI Removes Rows if Column is null

[powerbiwork]

Hi so I import my data from salesforce but I notice when I try to remove unwanted column some of my rows disappear. Is this because PBI removes rows with nulls if so how do I get it to not remove the row when there are nulls.

Thanks

[PhilipTreacy]

Hi @powerbiwork 

Please share the query steps (M code) so I can see what else is going on.

Thanks

Phil

[vanessafvg]

can you explain how you are doing this?  rows will only disappear if you remove null values, it wont remove rows when you remove a column.

[powerbiwork]

So import data from Saleforce there are about 155,000 rows when I choose the columns in transform data the the 155,000 rows turn into 6,000 rows only lets say

[vanessafvg · Accepted solution]

hi again

its really hard to say whats hppening without being able to see what you doing.

Where are you removing the columns in power query?  its impossible to diagnose your issue without sharing how you are doing this.

in the transform data it will only show you the first 200 rows of data.

If you import all the data without remove columns does it give you 155 000?

then when you remove columns in transform data you only have 6000.

the only reason this could be happening is that when you remove the columns you remove the granularity, ie the detail.  But like i say very difficult do diagnose with the limited information you are giving,  Please share some screenshots with the issue.

Are you bringing back master data or transactional data? are you pulling views from sales force or tables?

[powerbiwork]

I am pulling from salesforce. The full set of data have about 155,000 rows

but after I choose columns in transform data

it only come back with 2,477 rows