Reply
atablkblt1997
New Member

Combing CSV files in dataflow and dataflow does not refresh and grab new csv files.

I have a dataflow that I want to go in to a sharepoint folder and combine all of the csv files in that folder. Each day a new file is automatically added to that folder. I created a dataflow, but the problem is when I refresh the dataflow the number of csv's that it combines is static. So whatever csv files were in the folder when I created the dataflow is what it refreshes. It does not find new csv files. This is the code I am using:

2022-08-23_6-20-46.jpg

 

Any ideas why it won't pick up a new csv file the next day when it moves into that folder?
1 REPLY 1
otravers
Community Champion
Community Champion

What happens when you edit the dataflow and refresh the data preview? Is it possible you have filters in the custom function you're invoking?

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)