Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Download Power BI report in code

Hi everyone,

 

Is it possible to download a Power BI report in code (C# for example)?

We would like to automate a download of a existing Power BI Report.

 

Thank you in advance for your feedback!

Kind regards.

Need Help
Tips and Tricks
  • TedPattison's avatar
    TedPattison
    7 years ago

    Sorry I misunderstood.

     

    Currently, the only support for export-to-pdf is in Power BI Desktop and not in the Power BI Service. Unfortunately, there is no way to automate generating PDF files with Power BI Desktop. I do not think what you want will be possible until the Power BI team adds export-to-pdf capabilities to the Power BI Service and also support to call it through the API. This feature is on the Power BI team's roadmap but I have no idea when we might see this in preview.

5 Replies

  • TedPattison's avatar
    TedPattison
    Microsoft Employee
    7 years ago

    Yes, you can use the Power BI SDK which provides methods in PowerBiClient.Reports. Here is an example.

     

     

    PowerBIClient pbiClient = GetPowerBiClient();

    var reportStream = pbiClient.Reports.ExportReportInGroup(appWorkspaceId, report.Id);
string filePath = @"C:\tempExport\" + report.Name + ".pbix";
FileStream stream1 = new FileStream(filePath, FileMode.Create, FileAccess.ReadWrite);
reportStream.CopyToAsync(stream1).Wait();
reportStream.Close();
stream1.Close();
stream1.Dispose();

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi TedPattison

       

      First of all thank you for your reply and info/code sample.

      Excuse me, i rephrase, can you download a PDF/PNG from a report in C# from a report or dashboard?

       

      • TedPattison's avatar
        TedPattison
        Microsoft Employee
        7 years ago

        Sorry I misunderstood.

         

        Currently, the only support for export-to-pdf is in Power BI Desktop and not in the Power BI Service. Unfortunately, there is no way to automate generating PDF files with Power BI Desktop. I do not think what you want will be possible until the Power BI team adds export-to-pdf capabilities to the Power BI Service and also support to call it through the API. This feature is on the Power BI team's roadmap but I have no idea when we might see this in preview.

  • umeshlade's avatar
    umeshlade
    New Member
    5 years ago

    Is is possible to download power BI report using SSIS script or using C#?

    I want to automate report download from power bi server by passing dynamic parameter. 

     

    Anonymous TedPattison  how you done this in your application