Forum Discussion
imported data not refreshshing in visuals
- 3 months ago
Hello vickster3659,
The 12th CSV was likely imported successfully, but not added to the final appended query used by the visuals.
Check the following:
- Confirm the 12th file contains rows in Power Query.
- Verify the Append step includes the new file/query.
- Ensure column names and data types match the previous files.
- Select Close & Apply to refresh the model.
- Check for filters or slicers excluding the new month.
For future monthly files, using Folder import is usually easier and more scalable than manually appending CSVs each month in Microsoft Power BI Desktop.
Docs:
Combine files (binaries) in Power BI Desktop
Folder
Hi and welcome to Power BI 😊
First thing I’d check: is the structure of your 12th file exactly the same as the others?
Even small differences can break the append, for example:
- column names slightly different
- extra or missing columns
- different data types (e.g. text vs number)
If you manually appended the file, make sure the 12th CSV is included in the append query. Sometimes it’s as simple as the new file not being added there.
For future monthly files, using Folder import is usually easier and more scalable than manually appending CSVs each month in Microsoft Power BI Desktop.
Hope this helps! If it doesn’t solve the issue, feel free to share a bit more detail and we can take a closer look 👍
- danextian3 months agoSuper User
It’s also worth noting that Power Query is case sensitive. ABC and abc may look the same, but they are treated as entirely different columns.