Forum Discussion

ZD1's avatar
ZD1
New Member
6 years ago

Date column not provided

I am currently using a weekly excel report within PowerBi that I recieve from a 3rd party source each week but they do not provide a date column. Initially this wasn't really an issue and the dashboard element worked fine. However the business would now like to be able to compare weekly figures using the same Powerbi report instead of seperate reports published each week. Unfortuntately as no date column has been provided I can't figure out how to add and merge 'new weekly reports' recieved into the existing query without it making it seem that all data is from the same date period.

 

please help?

Need Help

1 Reply

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    Hi ZD1 ,

     

    Are you using folder connection ? If yes, you can use the date modified or date created (metadata) as date for your report.