cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PeacefulBeing Frequent Visitor
Frequent Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
TedPattison
Advisor

Re: Download Power BI report in code

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.

4 REPLIES 4
TedPattison
Advisor

Re: Download Power BI report in code

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();

 

 

PeacefulBeing Frequent Visitor
Frequent Visitor

Re: Download Power BI report in code

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
Advisor

Re: Download Power BI report in code

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.

PeacefulBeing Frequent Visitor
Frequent Visitor

Re: Download Power BI report in code

No, it is my fault for not stating my question properly Smiley Happy

Thank you very much for both replies as they helped me both!

 

kind regards

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 373 members 3,343 guests
Please welcome our newest community members: