Forum Discussion
excel file with date tabs
I solved the problem by creating a new tab with dropdown for each month tab that pulls the data from the monthly tabs. Then in powerbi, just display the new tab and each month all that is needed is to select the current month from the dropdown in the spreadsheet and it will automatically update to the new month numbers.
sdulaney,
I can't think of any methods can be used in Power BI to automated the process that select a tab based on the current month.
A workaround is to generate new Excel file with same name each month and replace the existing file in OneDrive for business.
Regards,
Lydia
I solved the problem by creating a new tab with dropdown for each month tab that pulls the data from the monthly tabs. Then in powerbi, just display the new tab and each month all that is needed is to select the current month from the dropdown in the spreadsheet and it will automatically update to the new month numbers.