Manchester Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Auto generate boards and export to PDF

  • 1.  Auto generate boards and export to PDF

    Posted Aug 18, 2017 10:28 AM

    I'm not sure if this is possible or not.

    What I am looking to do, is allow our clients to produce a custom report (different per client). Which will take a set of defined data, pass in a parameter and then on a defined loop, create a series of PDF reports (filtering the data), which can then be stored in a document storage area. Similar to a mail merge in excel.

    Is this possible? Any resource links would be appreciated!



    ------------------------------
    Daniel Reil
    Technical Director
    Gemstone Software
    Liverpool
    ------------------------------


  • 2.  RE: Auto generate boards and export to PDF

    Posted Apr 26, 2018 04:40 AM
    Yep, I'm interested in this too.

    The closest I've got to a solution is using query string parameter to produce a report for each "filter" I need. Then created a master PBI report, to programmatically create the URL I require, per each report...

    <url to PBI service>/?filter=<FilterName> eq "<FilterByValue>"

    www.powerbiservice.com/here_is_my_report?filter=CRMProject/ref eq "54330"

    ------------------------------
    Carl Hunter
    Business Intelligence Developer

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