Forum Discussion
Power Query Excel data from Variable / Dynamic Worksheet...
Hi All, I'm using power query to pull data from a weekly file via filepath and name in cell reference, which is working perfectly. However when I change week number, worksheet name for next week f...
You may change in Navigation step the code which is usually looks like
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],on
Sheet1_Sheet = Source{0}[Data],Other words, use relative reference instead of absolute one.
Thank you Sergei.
I removed 1st column (Name) showing sheet name added by query itself and refresh query. It did work and now sheet Name column refreshing as well without extra hard coding. Also I don't have Navigation step in my applied step may be because of setting file Path for the source.
Thanks again for a quick suggestion which may be helpful in some other but similar cases.
I removed 1st column (Name) showing sheet name added by query itself and refresh query. It did work and now sheet Name column refreshing as well without extra hard coding. Also I don't have Navigation step in my applied step may be because of setting file Path for the source.
Thanks again for a quick suggestion which may be helpful in some other but similar cases.