SOLVED
Home

Power Query Parameter

%3CLINGO-SUB%20id%3D%22lingo-sub-1115184%22%20slang%3D%22en-US%22%3EPower%20Query%20Parameter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1115184%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20filter%20a%20table%20by%20month%20using%20a%20paramater%20where%20a%20person%20enters%20a%20date%20and%20if%20it%20finds%20it%20a%20table%20will%20return%20with%20all%20the%20information%20from%20that%20date.%26nbsp%3B%20I%20am%20getting%20a%20privacy%20message%20on%20my%26nbsp%3BHumanResources%20vEmployeeDepartment%20(2)%20query.%26nbsp%3B%20%26nbsp%3B%20I've%20looked%20at%20many%20blogs%20regarding%20this%20problem%20and%20I'm%20having%20trouble%20understanding%20how%20to%20fix%20it.%26nbsp%3B%26nbsp%3B%20Please%20help.%26nbsp%3B%20Thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1115184%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1115509%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Parameter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1115509%22%20slang%3D%22en-US%22%3EI%20see%20you've%20had%20(as%20of%20this%20writing)%2022%20views%20but%200%20replies.%20I%20think%20part%20of%20the%20problem%20is%20that%20your%20problem%20isn't%20described%20in%20its%20fullness.%20For%20example%2C%20are%20you%20part%20of%20Human%20Resources%3F%20Do%20you%20have%20access%20to%20ALL%20of%20the%20information%20on%20that%20database%3F%20It's%20not%20at%20all%20clear%2C%20I'm%20thinking%2C%20that%20this%20is%20specifically%20an%20Excel%20problem.....what%20makes%20you%20think%20it%20is%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1115619%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Parameter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1115619%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F434928%22%20target%3D%22_blank%22%3E%40lmk001%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECombine%20parameter%20query%20with%20main%20one%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3Elet%0A%20%20%20%20%2F%2FHireDate%20%3D%20DateParamQuery%2C%0A%20%20%20%20HireDate%20%3D%20Date.From(%0A%20%20%20%20%20%20%20%20Excel.CurrentWorkbook()%0A%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%5BName%3D%22DateParamTable%22%5D%0A%20%20%20%20%20%20%20%20%7D%5BContent%5D%7B0%7D%5BStartMonth%5D%0A%20%20%20%20)%2C%0A%20%20%20%20Source%20%3D%20Sql.Databases(%22KANEFF%22)%2C%0A...%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1116323%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Parameter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116323%22%20slang%3D%22en-US%22%3EI%20think%20this%20answers%20my%20question.%20Thank%20you.%20Sorry%20for%20the%20confusion.%3C%2FLINGO-BODY%3E
lmk001
Occasional Contributor

I'm trying to filter a table by month using a paramater where a person enters a date and if it finds it a table will return with all the information from that date.  I am getting a privacy message on my HumanResources vEmployeeDepartment (2) query.    I've looked at many blogs regarding this problem and I'm having trouble understanding how to fix it.   Please help.  Thanks.

 

 

3 Replies
Highlighted
I see you've had (as of this writing) 22 views but 0 replies. I think part of the problem is that your problem isn't described in its fullness. For example, are you part of Human Resources? Do you have access to ALL of the information on that database? It's not at all clear, I'm thinking, that this is specifically an Excel problem.....what makes you think it is?
Highlighted
Solution

@lmk001 

Combine parameter query with main one like

let
    //HireDate = DateParamQuery,
    HireDate = Date.From(
        Excel.CurrentWorkbook()
        {
            [Name="DateParamTable"]
        }[Content]{0}[StartMonth]
    ),
    Source = Sql.Databases("KANEFF"),
...

 

 

Highlighted
I think this answers my question. Thank you. Sorry for the confusion.
Related Conversations
Sorting problem with imported data from query
DenisL in Excel on
5 Replies
Query Design
Siriah in Access on
1 Replies
Power Query freezes in Excel
ire123 in Excel on
0 Replies