Dear All,
I have an Excel Power Query I need to make the Source as dynamic based on the value on MyPN!K2 cell as in the below screenshot
![Image Image](/board/proxy.php?image=https%3A%2F%2Ffilestore.community.support.microsoft.com%2Fapi%2Fimages%2F685e8ab9-4144-48e9-90f3-334a831f6401%3Fupload%3Dtrue%26fud_access%3DwJJIheezUklbAN2ppeDns8cDNpYs3nCYjgitr%252BfFBh2dqlqMuW7np3F6Utp%252FKMltnRRYFtVjOMO5tpbpW9UyRAwvLeec5emAPixgq9ta07Dgnp2aq5eJbnfd%252FU3qhn54PTw5wzRGAFaXpntG7CZJyYnf1loa8c8Cuskia%252FHRUB9qyd2WtWaKCSmdaqeBFQ8q9yOlqqZ%252FYvbLm%252B56MBPPVntM1zO9Jsx9fHAA8kcoQsLsg0FSXclmS5icdAxK4AfbI5reCxoghEL5Dr7%252BuZliiVgu0VcRqhBmWlMK7l6wXC%252B7PzgUpbpf%252B%252B3VEw%252FT8pCMAH6a3fgA5o4RtUVDDn%252FZ6cU8L0mHQ3smKflLDEPLgUaNvyqmb4WI2TceVrOBPkCCML0ZMIQ7Yd0bF1BBtb5HnVBEdpCSI7GqLfLRlLPGzGE%253D&hash=12f6688ab9afb61644f7d7ede6f63832)
to have this line Source = Excel.Workbook(File.Contents("C:\TEST\MyFile\January2024.xlsm"), null, true), becaming Source = Excel.Workbook(File.Contents(MyPN!K2), null, true),
Any way to do it?
Thanks
I have an Excel Power Query I need to make the Source as dynamic based on the value on MyPN!K2 cell as in the below screenshot
to have this line Source = Excel.Workbook(File.Contents("C:\TEST\MyFile\January2024.xlsm"), null, true), becaming Source = Excel.Workbook(File.Contents(MyPN!K2), null, true),
Any way to do it?
Thanks