Answered

Filter a paginated report with Automate

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a paginated report with a column with four distinct values. I want to create a flow to filter paginated report four times and export the report filtered. Can i use automate and "Export To File for Paginated Reports" object to do that?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

JonDoesFlow 1,304 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Here is a link that might help you -

try this instead

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-automate-paginated-local-file

---------------------------------------------------------------------------

If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !

Blog - JonDoesFlow
Twitter - JonDoesFlow
YouTube - JonDoesFlow

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Jondoesflow, thanks for your help, the url doesnt exist

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Navigating thought the documentation i have seen this post:
https://learn.microsoft.com/en-us/power-bi/paginated-reports/parameters/report-builder-parameters

Then, you can create a parameter with Power BI Report Builder (I have followed this tutorial to achive that https://www.youtube.com/watch?v=k0BnZJwuuLM&ab_channel=AnalyticswithNags) and then, you can filter the report with this parameter. In the "Export To File for Paginated Reports" object you can call to the parameter and the value you want to filter.

I only have a problem with this solution, you cant edit the report with power bi Service from the moment you edit the report itself with report builder. As you can see, there is no option to change between Visualization/Edition

But, as you can see here, we cant do nothing with it:
https://community.fabric.microsoft.com/t5/Developer/Disappear-quot-editing-mode-quot-after-editing-amp-publish-from/m-p/3367326

Was this reply helpful? Yes No