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.
1 ACCEPTED SOLUTION
Hi @Prasanthh60 -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.
Find and tag duplicate values in Power Query (youtube.com)
Hope this helps.
Proud to be a Super User! |  |
Hi @Prasanthh60 -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.
Find and tag duplicate values in Power Query (youtube.com)
Hope this helps.
Proud to be a Super User! | |
