Forum Discussion

selster's avatar
selster
New Member
4 years ago

Populating a pdf form with power bi query

Hello,  Is it possible to take the data from each row of a power bi query table and then use this to fill in a pdf form?

======sample power bi table ==========

====   col1 -- col 2 --

row1 = 123 --  up --

row2 = 456 --  down --

==============

the pdf form would have two fields that are fillable

number = col1

direction = col2

============

I realize that this can be done with online solutions such as with a sharepoint list or, for instance, with smarsheet but I am wondering if it can also be done with the desktop version of power bi query.

Thank you,

Steve

Need Help

3 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Icon for Community Champion rankCommunity Champion
    4 years ago

    I am not sure if you are able to push data to PDF form using Power Query. You may need to look into Power Automate to achieve this.

    • selster's avatar
      selster
      New Member
      4 years ago

      Posting to the desktop power automate forum, then.  Still if anyone know how to do this with power bi, I would very much appreciate it. SE

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi selster 

     

    It seems there are multiple rows in the sample table. When you use them to fill in a pdf form, you want all values there or just need one row values? 

     

    In Power BI Desktop, you could add visuals on a report page and use these two columns to populate them. Then export the report to PDF. See Export reports to PDF - Power BI | Microsoft Docs

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.