Forum Discussion
Query Parameters to get all data in Service
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 contain...
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.