Forum Discussion

fstupot's avatar
fstupot
Icon for Helper II rankHelper II
5 years ago

changing data source tab name but not breaking exisiting visuals/reports

hi guys,

 

i have some reports on powerbi, where rather than manually updating i want to change to an automated way. where the data source is automatically refreshed each day.

 

the issue i have is that when is that now i want it to automatically update, the data source i pull from will have a different name.

 

i know how to change the data source. what i am worried about is that the sheet it is pulling from will no longer have the tab/sheet named as "xx". so i presume that any calculations or reports that point to "xx" will no longer work as it will noe be called "sheet 1"

 

how can i get around this without opening up the data source and renaming the tab to "xx" each time?

 

thanks

 

lucy x

1 Reply