Not upload all excel spreadsheet in powerBI desktop

[Giovani]

I have a spreadsheet with 500.000 rows and 19 columns that I am trying to upload to PowerBI desktop.

When I upload there are only 65.000 rows.There is a way that I can upload all spreadsheet content?

[v-haibl-msft · Accepted solution]

@Giovani

As @Caitlin_Knox suggested, could you please create a measure like following one to check the actual rows imported to PBI Desktop?

Measure = COUNTROWS( 'TableName' )

I just tested with latest Nov 2017 version of PBI Desktop and I could import more than 65000 rows here.

Best Regards,
Herbert

[Giovani]

Hi Herbert,

I couldn`t solve this issue. I removed Power Bi Desktop and installed again. 

Now it is working and loading all data.

Thanks.

[Caitlin_Knox]

Are you seeing that row coutn in the query editor? Or did you use the COUNTROWS function to check your model? I know in the Query editor, it doesn't necessarily bring in all the rows right there. I would try adding a calculated measure to count the rows once you've loaded the data to the model from the editor.

[Giovani]

Actually, it stops to load the data in 65.0000 rows. 

I am construction Line and stacked column chart and that doesn't have the date after the 65.000 lines.  Meaning that this data didn`t load.