Not all rows from csv file are imported into the Power BI or Power Query

Question

Hello There,

I am trying to import data in csv file (size: 585 MB) to Power BI through Power Query.

I am aware that the data in csv file contains more than 1 million rows, but it shows only 1 million rows in Power Query & Power BI as well.

I don't know what exactly went wrong.

Note: I don't have Notepad++

Thank You in advance.

Answer 1

Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/

--please don't forget to upvote and if the reply is helpful--