Power Query: Files With No Data

[Pulsar3000]

Hello All:

I'm using power query to import multiple CSV files with different sets of data into one workbook in which each tab reflects one of the imported CSV files. The source used is a folder via a dynamic path that changes based on the month.

An issue I've run into is that sometimes the same report may not have any data in one month vs another month. As a result, if I import a report/file one month with data and the same report next month but with no data, it keeps the data from the prior month/file.

Q1. What is the best way to avoid this without using VBA?

I know I can filter the file size in a file listing within Power Query but the issue remains.

Q2: Can you use Power Query to change a tab color based on a condition from a separate tab?

 

[Matt Allington]

PQ reloads everything from scratch on each refresh (unless you use incremental refresh). If you change the files each month, what behaviour are you expecting?

PQ loads data. It cannot change tab colour

 

[Pulsar3000]

PQ reloads everything from scratch on each refresh (unless you use incremental refresh). If you change the files each month, what behaviour are you expecting?

PQ loads data. It cannot change tab colour

I have two different circumstances.

1. If there's no data, I'd like to simply import a blank table.

2. I need to merge two tables and if one of them has no data, I need that table excluded from merging. A conditional merge based on tables having data.