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

[Anonymous]

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.

Need Help

Power BI 

[v-robertq-msft]

Hi,

Is there any screenshots or video that can show your error in detail?

As far as I’m concerned, the data size limitation for the import mode dataset is 1 GB, which is highly compressed to around 10x.

What’s more, Import models require from a Power BI service resource perspective:

• Sufficient memory to load the model when it's queried or refreshed
• Processing resources and additional memory resources to refresh data

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[Anonymous]

Hi, 

The error is not popping in Power BI. But the actual data in the csv file is not showing up entirely in the Power BI or Power Query. It shows only 1 million rows. Rest are missing.

Thanks.

Best Regards,

Arul

[Anonymous]

Hi,

Please find the screenshot. Is the problem with file origin or Power BI?

[v-robertq-msft]

Hi,

Is this an issue related to the CSV file?

Would you like to change the file type to xlsx to connect again check if the error can disappear?

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[Anonymous]

Hi,

I changed it to Excel, Now it's working.

How I did:

I break down 4 quarter data in 4 different file (each contains 400k rows). I tried with one quarter file with 400k rows data, it's working in Power BI. 

Now, I have a doubt on how to combine all quater data files to make one report in Power BI dashboard.

Thanks!

Best Regards,

Arul

[v-robertq-msft]

Hi,

You can try the “Append query as new” function in the Power query:

https://docs.microsoft.com/en-us/power-query/append-queries

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[Anonymous]

Got it, Thanks!

Best Regards,

Arul

[Anonymous]

Hi,

I am trying to create the customized financial quarter. So how to change the current format from "4Q 2020" to "Q4 2020" in the Quarter year column.

Formula used:

monthTable = var FullCalendar = ADDCOLUMNS(CALENDAR("2020/10/1",today()),"Month Number",MONTH([Date]),"Year",YEAR([Date]),"Year-Month",LEFT(FORMAT([Date],"yyyyMM"),6),"Year-MonthName",Format([Date],"MMMM") & " " & YEAR([Date]),"Quarter",if(MONTH([Date])<4,"Q1",IF(MONTH([DATE])<7,"Q2",IF(MONTH([DATE])<10,"Q3","Q4"))),"Quarter Year",FORMAT([Date],"Q""Q") & " " & YEAR([Date]))

return

SUMMARIZE(FullCalendar,[Month Number],[Year],[Year-Month],[Year-MonthName],[Quarter],[Quarter Year])

Thanks!

[v-robertq-msft]

Hi,

If you want to get help from DAX in the Power BI, please refer to the DAX forum of the Power BI community so that experts in DAX can help in advance.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[Anonymous]

Thank You very much!!