Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.