Power Query Parameter

[lmk001]

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.

[#2]

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?

[#3 · Accepted 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"),
...

[#4]

I think this answers my question. Thank you. Sorry for the confusion.