Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Need different sheet names to be called using query and link in these places in Power Query Advanced Editor. I'm using another table to get the sheet name and call that as a query, but not sure how to link in these place, whatever I type, it is showing as error. Need help, thank you in advance for spending time on this. Much appreciated.
Getting this error
M is a case-sensitive language. Should be List.Contains not list.contains thus you're getting an error that the latter wasn't recognized.
Proud to be a Super User!
Hi @tjayapal ,
You can actually connect to multiple sheets in an Excel file easily. Remove all steps after Source in Applied Steps. You will see the list of worksheets, named range, etc in the preview. Filter to Sheet under Kind column and just select the worksheets you need.
Proud to be a Super User!
Hey. Thanks for responding spontaneously.
I understood your answer, but what I want is that power query editor to act dynamic. In another sheet, I just have only one table where I will fill only one value which is the name of those sheets which I have in my database sheet. So when I change the date in the excel, it should automatically refresh its value, using the sheet which I mentioned instead of manually changing the sheet every time in power query editor. Hope I explaiend clear, if not let know so that I will try to eloborate more.
Here's what I would do
Change Sheets to the actual query name contains a list of sheet names.
Proud to be a Super User!
Hey, I can understand what you are trying to say, but I'm really a starter and not sure how to get the 26-Apr-2022 as value, could you help on the exact situation?? See below for screenshot
Again thank you so much