Forum Discussion
Do I have to ""Load to.. Table" to populate dropdown?
Yes, I mean green table.
You can't create data validation list from power query connection or data model table, power query shall return the table into the Excel sheet to use it for data validation. Another story you may place it into separate sheet and hide this sheet.
Michelle, you don't need to load the table into data model in this case, it's enough only to land it into Excel sheet.
SergeiBaklan thanks (again) for your reply. I am trying to avoid creating a new table in excel. I was hoping I could just load it into the data model rather. I assume by "land it in excel" you mean create the green table as shown?
Yes, I mean green table.
You can't create data validation list from power query connection or data model table, power query shall return the table into the Excel sheet to use it for data validation. Another story you may place it into separate sheet and hide this sheet.
SergeiBaklan got it! Thank you. 🙂
