Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
This issue seems has been asked several times in this forum, but I haven't found any solution workable to my question, so I am posting here:
I am creating a function by duplicating one query, and modifiy the query steps by advanced editor. The purpose is to apply the same query steps to another worksheet in another Excel workbook.
In the advanced editor, I added "quartername" as the parameter, which is the file name of the Excel workbook. However when I input the name of the workbook and the click "invoke", an error message pops-up as "query. Expression.Error. Snapshot as below. I wonder what caused the error? The details only show [Table] which I don't quite understand.
Both workbooks contain several worksheets, but my target sheets are both called "quality data". And the format of both "quality data" are identical. BTW, the file name of the Excel workbook contains Korean character.
Please kindly advise any thoughts or comments, thank you so much!
Solved! Go to Solution.
Hi @OZMckenzie ,
Try this on #"Filtered Rows2" step:
(each [Name] = quartername)
Instead of string value, use the parameter defined as text,
It looks like you are not using the parameter quartername, only the string "quartername" for the SelectRows function.
Hi @OZMckenzie ,
Try this on #"Filtered Rows2" step:
(each [Name] = quartername)
Instead of string value, use the parameter defined as text,
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
5 | |
5 | |
5 | |
4 |