Sep 09 2020 09:03 PM - edited Sep 09 2020 09:05 PM
Hello,
As shown in the screenshot below, I am populating my dropdown (ie data validation list applied to cell E5) from a table (Table_PPeriodQueryResults) which was a result of my query PPeriod_Query.
Question:
As I have selected "Add this data to the data model" for the query, Is it possible to populate my dropdown list without having to load the data into a table?
As always, thank you.
Michelle
Sep 10 2020 07:49 AM
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.
Sep 10 2020 07:53 AM
@Sergei Baklan 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?
Sep 10 2020 08:27 AM
SolutionYes, 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.
Sep 10 2020 09:38 AM
@Sergei Baklan got it! Thank you. :)
Sep 10 2020 09:43 AM
@Michelle99 , you are welcome
Sep 10 2020 08:27 AM
SolutionYes, 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.