Refreshing everyday it will take every day date source file

[saikiran]

Hi,

        I have excel files from 29-07-2019 to 30-08-2019 in share point.First i am taken 29-07-2019 excel file and conncet to power bi desktop and cretaed one table visual. In this table visual i am showing 29-07-2019 for Date Column and another column i am showing One field count.

My problem is if i am clicking on refresh it will take next day date(30-07-2019) and same field count.this values will show along with previous date column like this i want to show if i am clicking the refresh everday it will go to sharepoint and find the current day source file and shows the Values. Is it possible?

Please any body help me as soon as possible. If your not understand the requirement please ask me i will explainSource files

[v-lili6-msft]

hi, @saikiran 

You could try this way:

Get data from a Folder in Power BI, then combine them and add a conditional filter for file name column.

https://www.jetglobal.com/blog/power-bi-load-data-from-folder/

Best Regards,

Lin

[saikiran]

Hi All source files are same