Average/day from CSV-file gives rowcount 1

[selibern]

Hello,

I have some data from a CSV-file where I want to have the following data:

1. Avarage per day

2. Row count per day (to see if there's any data missing)

When doing this from an Excel-file as data source I get this:

Average April 1st: 2,28

Row count: 8640

(This is the same data compared to the pivo-tables in excel)

When I have a CSV-file the source (with exactly the same transformation-data-settings) I get this instead:

Average April 1st: 0,05

Row count: 1
(This is the first row of April 1st, it seems like PowerBI takes the first values and is fine with that)

Questions

Do I have to convert the file to Excel everytime before using it in PowerBI?

Is there any way around it?

Why does PowerBI stop at the first row/day with the CSV-file?

[Vijay_A_Verma]

When you import csv in Power BI, it will immediately throw up a table like below picture (at the end of this post)

Can you do a fresh import of this csv in your Power BI (not using existing model) and see if you get this kind of table?

if yes, my guess is that your source may not be up-to-date....Please check if your source is like this for csv.

Source = Csv.Document(File.Contents("C:\Users\abcdef\Documents\1.csv"),[Delimiter=",", Columns=10, Encoding=65001, QuoteStyle=QuoteStyle.None])