Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
6 years ago
Solved

send report in pdf

Hi all,   when I send reports via subscription the receiver gets it in .png file and a link to the report. isnt it possible to send the report in pdf?   Thanks.
Need Help
  • rpatkar's avatar
    rpatkar
    6 years ago
    Subscribing to PBIX reports as PDF is currently not supported. It’s in our planned backlog. We will get to it in coming months but no specific timeline to share yet.
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
I don't believe so, you can export it as a PDF. Might be able to do it with Power Automate and Power BI REST API.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Greg_Deckler ,

 

Could you please let me know on how to Automatically Export Power BI Report in PDF with the help of Power Automate and Power BI REST API.

 

It would be very helpful for us.

 

Thanks in Advance

Prakash

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Greg_Deckler ,

       

      Thanks for your reply.

       

      I tried to Export to PDF with the below code but was getting 1 or more errors.

       

      Invoke-PowerBIRestMethod -Method POST -Url reports/76746e90-02e9-4677-ac7a-0ea5755c6c47/ExportTo -Body PDF -OutFile PDF

       

      Could you or anybody else please help me out in this code? I would like to export it in pdf.

       

      Thanks

      Prakash

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago

        I believe the correct code is closer to:

         

        $params = @{"format"="PDF"}

        Invoke-PowerBIRestMethod -Method POST -Url reports/a9b01471-0982-4e14-bbf7-ddb60a89ab43/ExportTo -Body $params

         

        However, I am getting some kind of Write error:

         

        Invoke-PowerBIRestMethod : One or more errors occurred.
        At line:1 char:1
        + Invoke-PowerBIRestMethod -Method POST -Url reports/a9b01471-0982-4e14 ...
        + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIR
        estMethod], AggregateException
        + FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod