You’re offline. This is a read only version of the page.
4
Hi everyone, I come with an age old problem but can't seem to find a good solution in previous posts.
I have a flow to export Power BI Reports with filters defined from a large spreadsheet. Due to a need for concurrency/parallelism I've been constructing the reportLevelFilters using multiple "Compose".
Problem is the reportLevelFIlters doesn't actually get applied to the report after export. However, when I hardcode an identical filter, it seems to work - as soon as I switch back to a variable it doesn't get applied.
I've double checked the filter contents in both cases, did string compares for the api call logs, tried trimming white spaces, string() converts and even uricomponent encoding, none which seems to solve the issue.
What works (hardcoded filter):
Identical filter but in a compose output (Doesn't Work):
Test API trace/log of the compose output parameter, it is identical to the hardcoded one:
Identical filter but with components constructed within the Filter - 1 field:
Same the trace/log of the API call is identical.
Hi everyone, I come with an age old problem but can't seem to find a good solution in previous posts.
I have a flow to export Power BI Reports with filters defined from a large spreadsheet. Due to a need for concurrency/parallelism I've been constructing the reportLevelFilters using multiple "Compose".
Problem is the reportLevelFIlters doesn't actually get applied to the report after export. However, when I hardcode an identical filter, it seems to work - as soon as I switch back to a variable it doesn't get applied.
I've double checked the filter contents in both cases, did string compares for the api call logs, tried trimming white spaces, string() converts and even uricomponent encoding, none which seems to solve the issue.
What works (hardcoded filter):
Identical filter but in a compose output (Doesn't Work):
Test API trace/log of the compose output parameter, it is identical to the hardcoded one:
Identical filter but with components constructed within the Filter - 1 field:
Same the trace/log of the API call is identical.
Share
Report
All responses (
Answers (
