Data Source settings basic

[Anonymous]

Hi All,

Many Thanks in advance. I had combined three distinct sources to produce a matrix table and it works well.

However I have trouble in sources. Getting the below error.

I have dedicated folders for all the type of sources separately. Please guide me on how,

1. For source No: 1, I will download every day 1 excel and will place in the folder. Power Bi should count data from all the excel.

2. For source No: 2, I will be deleting the existing excel report and will be pasting a new one.

3. For source No: 3, if its not too much to ask, I will download every day 1 excel and will place in the folder but each excel may or may not have duplicate data from the previous one and my matrix shud capture distinct count.

[rajendraongole1 · Accepted solution]

Hi @Anonymous -For the above snapshot error, can you please check the new files you're adding have the same column structure as the previous ones. If a column is missing or has been renamed, Power BI will return this kind of error.

Data Validation in Power Query: You can add steps in Power Query to validate that required columns exist in each file before loading them. If a column is missing, you could generate a warning or handle the missing data gracefully.

https://www.youtube.com/watch?v=9sfCDCpWTfc&pp=ygUqQ29tYmluaW5nIG11bHRpcGxlIEV4Y2VsIGZpbGVzIGluIFBvd2VyIEJJ

Find and tag duplicate values in Power Query (youtube.com)

Hope this helps.