Query Parameters to get all data in Service

[uif19085]

Hello everyone. First time trying to set up PowerQuery to bring all the data in Service if the Parameter is empty. First step was to create a List of Projects with the help of the Column that contains all the project names named PROJECT_NAME, then i've created a Parameter this:

Then i've tried to set up the PowerQuery in the AdvancedEditor and it looks like this:
let
Source = Oracle.Database("{Server}[Data],
PBI_METRIC_EVOLUTION_V1 = DB_PRD{[Name="PBI_METRIC_EVOLUTION_V"]}[Data],
FilteredRows = if ProjectName = "" then PBI_METRIC_EVOLUTION_V1 else Table.SelectRows(PBI_METRIC_EVOLUTION_V1, each [PROJECT_NAME] = ProjectName)
in
FilteredRows

Then for testing i've put an empty string locally in EditParemeters and also on Parameter in Service but it filters with nothing, get only an empty Table. Do i miss something, i'm doing something wrong? Thank you

[ToddChitt]

When you refer to Parameters in Power Query, preface them with #:

 #ProjectName

If the parameter contains spaces in the name, wrap it in single quotes:

#"Project Name"

Do this: Write your Power Query WITHOUT the parameters. Does it work? Can you post that, plus a sample of what the parameter might contain?

If this answers your question, please consider marking it as a Solution. Or give Kudos to helpful replies.