Forum Discussion

Sibrulotte's avatar
Sibrulotte
Icon for Helper IV rankHelper IV
4 years ago

opening a pbix with report builder

hi, 

I've made a suuuuuuuuper nice pbix file that has been deployed to power bi services (dataset and report). 

 

Problem is, I've had a request to print to PDF all the 132 possible values of a filter. So I have to turn to power bi preport builder and use the paginated function.

 

Is there a way for me to open this with report builder or do I have to redo every visualtions again?

 

 

Need Help

8 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    No. The Report Builder is fundamentally different and cannot open a PBIX file.

     

    That said, you can connect to a Power BI Dataset from the Report Builder. This lets you use the tables and measures you've already built (but not any visuals).

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

     

    I'm wondering what method did you use to export all 132 reports based on filter values in the end. I'm in a very similar situation. Thank you!

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      2 years ago

      Anonymous There are a couple of options that come to mind.

       

      1. Make each report page a subreport within a list of all the parameter combinations you want.

      2. Create a list of parameters in SharePoint and use Power Automate to loop through the list and run + export the report for each set of parameters.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thank you for the response. Do i need a premium account to be able to do it? I'm currently having a pro license only/

  • Juansuas's avatar
    Juansuas
    New Member
    2 years ago

    Hi everyone! I've been working on a project with a similar situation: we need to generate 5,000 PDFs, applying one filter for each case. We used Power BI Desktop combined with a Python script using PyAutoGUI. The program takes control of the mouse, applies the filter by taking the value from a CSV, and then clicks on "File" -> "Export to PDF."