excel file with date tabs

[sdulaney]

I am new to Power BI and I want to create a dashboard to show an excel spreadsheet tracker on a TV that is already setup in excel with the correct forumlas and data sorted how they want it viewed.

The file is stored in OneDrive for Business and I just selected the content I wanted viewed and pinned it to the dashboard. That works great and I have it set to refresh the webpage to keep the data up to date and it is working great.

I just pinned the data from the existing excel file instead of creating a dataset since the layout in the excel file is how they want it displayed and importing as a datase sorts it alphabetically instead of how they want it viewed.

The problem I have is that the spreadsheet is setup with each month in a different tab in excel. So each month I have to manually go into the excel and select the tab for the current month and pin it to the dashboard and remove the old one. Is there any way for this to be automated to select a tab based on the current month instead of having to do this manually each month?

[v-yuezhe-msft]

@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

[sdulaney · Accepted solution]

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.