max rows

[Zakaria_1980]

Hi,

I have a DB where i have 1200 sites names, when I import data from excel sheet, and when looking in PBI desktop, I don't find almost half of the sites. is there any explanation to this please ?

after i was even transposing some columns, for each sites it will repeated 17 sites (based on the transposed colums) so i'll have 1200*17 and even with this i cannot find all sites

is there any limit in this PBI for rows ??

regards,

[Greg_Deckler · Accepted solution]

@Zakaria_1980 No, I've seen trillion row datasets in Power BI. Now, the Power Query Editor only displays the first 1000 rows as a preview, is that were you are experiencing this? If so, Close & Apply and all of your rows should be added.