Forum Discussion
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
- themistoklis
Community Champion
If you have only one sheet you can try the following (in Power query):
Change this
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
to this
Sheet1_Sheet = Source{0}[Data],
You can also check the following links:
https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254
https://exceleratorbi.com.au/import-the-first-sheet-in-a-workbook-with-power-query/