Folder Data Refresh issue

[Anonymous]

New to PowerBi.  I've connected a folder (that is on my desktop) as my data source to my dashboard, which was very easy to setup.  Now that i've added more files to that folder, PowerBI is not recognizing all the data in the new files.  I'm not getting an error message but with a data refresh, it is only reading the last row of a 30 row CSV file.  I'm getting this data from a program we use, so the formatting should be identical since it's an export off of that website. 

[TomMartens]

Hey @Anonymous ,

to provide a solution for your question or provide guidance to solve your issues, the information you provided is not sufficient.

This article describes how you can use the Advanced Editor to retrieve the query:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview#advanced-editor

Copy the query (M code) in your post.

Regards,

Tom

[Anonymous]

What other information would you need?

Is this the code you were referring to?

let
Source = Folder.Files("C:\Users\llubke\Desktop\PowerBI"),
#"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (2)", each #"Transform File (2)"([Content])),
#"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File (2)"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (2)", Table.ColumnNames(#"Transform File (2)"(#"Sample File (2)"))),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"Date", type date}, {"Player number", Int64.Type}, {"Player name", type text}, {"Session name", type any}, {"Type", type text}, {"Phase name", type text}, {"Duration", type time}, {"Start time", type datetime}, {"End time", type datetime}, {"HR min [bpm]", Int64.Type}, {"HR avg [bpm]", Int64.Type}, {"HR max [bpm]", Int64.Type}, {"HR min [%]", Int64.Type}, {"HR avg [%]", Int64.Type}, {"HR max [%]", Int64.Type}, {"Time in HR zone 1 (50 - 64 %)", type time}, {"Time in HR zone 2 (65 - 74 %)", type time}, {"Time in HR zone 3 (75 - 84 %)", type time}, {"Time in HR zone 4 (85 - 94 %)", type time}, {"Time in HR zone 5 (95 - 100 %)", type time}, {"HRZ4 Seconds", Int64.Type}, {"HRZ5 Seconds", Int64.Type}, {"Total distance [yd]", Int64.Type}, {"Distance / min [yd/min]", Int64.Type}, {"Maximum speed [mph]", type number}, {"Average speed [mph]", type number}, {"Sprints", Int64.Type}, {"Distance in Speed zone 1 [yd] (1.86 - 4.34 mph)", Int64.Type}, {"Distance in Speed zone 2 [yd] (4.35 - 6.83 mph)", Int64.Type}, {"Distance in Speed zone 3 [yd] (6.84 - 9.31 mph)", Int64.Type}, {"Distance in Speed zone 4 [yd] (9.32 - 11.80 mph)", Int64.Type}, {"Distance in Speed zone 5 [yd] (11.81- mph)", Int64.Type}, {"Number of accelerations (-50.00 - -3.00 m/s²)", Int64.Type}, {"Number of accelerations (-2.99 - -2.00 m/s²)", Int64.Type}, {"Number of accelerations (-1.99 - -1.00 m/s²)", Int64.Type}, {"Number of accelerations (-0.99 - -0.50 m/s²)", Int64.Type}, {"Number of accelerations (0.50 - 0.99 m/s²)", Int64.Type}, {"Number of accelerations (1.00 - 1.99 m/s²)", Int64.Type}, {"Number of accelerations (2.00 - 2.99 m/s²)", Int64.Type}, {"Number of accelerations (3.00 - 50.00 m/s²)", Int64.Type}, {"Calories [kcal]", Int64.Type}, {"Training load score", Int64.Type}, {"Recovery time [h]", type number}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Heart Rate Load (s)", each [HRZ4 Seconds]+[HRZ5 Seconds]),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Velocity Load ", each [#"Distance in Speed zone 4 [yd] (9.32 - 11.80 mph)"]+[#"Distance in Speed zone 5 [yd] (11.81- mph)"]),
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "Accelerations and Decelerations", each [#"Number of accelerations (-50.00 - -3.00 m/s²)"]+[#"Number of accelerations (-2.99 - -2.00 m/s²)"]+[#"Number of accelerations (2.00 - 2.99 m/s²)"]+[#"Number of accelerations (3.00 - 50.00 m/s²)"]),
#"Removed Blank Rows" = Table.SelectRows(#"Added Custom2", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
#"Removed Errors" = Table.RemoveRowsWithErrors(#"Removed Blank Rows"),
#"Renamed Columns" = Table.RenameColumns(#"Removed Errors",{{"Training load score", "Training load"}})
in
#"Renamed Columns"

[v-deddai1-msft]

Hi @Anonymous ，

Did all files in the folder show in source steps after you refresh it？

And I also recommend you report this as an Issue using issues.powerbi.com.  first check to see if it has already been reported. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai