SOLVED

Do I have to ""Load to.. Table" to populate dropdown?

%3CLINGO-SUB%20id%3D%22lingo-sub-1651362%22%20slang%3D%22en-US%22%3EDo%20I%20have%20to%20%22%22Load%20to..%20Table%22%20to%20populate%20dropdown%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1651362%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20shown%20in%20the%20screenshot%20below%2C%20I%20am%20populating%20my%20dropdown%20(ie%20data%20validation%20list%20applied%20to%20%3CSTRONG%3Ecell%20E5%3C%2FSTRONG%3E)%20from%20a%20table%20(%3CSTRONG%3E%3CEM%3ETable_PPeriodQueryResults%3C%2FEM%3E%3C%2FSTRONG%3E)%20which%20was%20a%20result%20of%20my%20query%20%3CSTRONG%3E%3CEM%3EPPeriod_Query%3C%2FEM%3E%3C%2FSTRONG%3E.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EQuestion%3A%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EAs%20I%20have%20selected%20%22Add%20this%20data%20to%20the%20data%20model%22%20for%20the%20query%2C%20Is%20it%20possible%20to%20populate%20my%20dropdown%20list%20without%20having%20to%20load%20the%20data%20into%20a%20table%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22screenshot.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217453iAB6C103DE6E2EE85%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22screenshot.png%22%20alt%3D%22screenshot.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20always%2C%20thank%20you.%3C%2FP%3E%3CP%3EMichelle%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1651362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1653247%22%20slang%3D%22en-US%22%3ERe%3A%20Do%20I%20have%20to%20%22%22Load%20to..%20Table%22%20to%20populate%20dropdown%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1653247%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F783767%22%20target%3D%22_blank%22%3E%40michellepace%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMichelle%2C%20you%20don't%20need%20to%20load%20the%20table%20into%20data%20model%20in%20this%20case%2C%20it's%20enough%20only%20to%20land%20it%20into%20Excel%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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?

 

screenshot.png

 

As always, thank you.

Michelle

5 Replies
Highlighted

@michellepace 

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.

Highlighted

@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?

Highlighted
Best Response confirmed by michellepace (Occasional Contributor)
Solution

@michellepace 

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.

Highlighted
Highlighted