Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I am trying to build the Body of a HTTP call to export a non-paginated report to PDF. The simple body just specifying the format works without issue:
{
"format": "PDF"
}
But when I try to add references to specific pages, it works but still exports the entire report and not just the pages I specify. Am I missing something in the syntax?
{
"format": "PDF",
"powerBIReportExportConfiguration": {
"Pages": ["ReportSectiona9e3231081c009928308","ReportSectionff5f4406621243856c08"]
}
}
Solved! Go to Solution.
You take the output of Getpages and modify it as needed.
{
format: "PDF",
powerBIReportConfiguration:{"value": [
{
"Name": "ReportSection59a3330f95669ad473e6",
"displayName": "1 Summary",
"order": 0
},
{
"Name": "ReportSectionc587b2defc60bdd51b80",
"displayName": "2 Weekly FY20Q3",
"order": 1
}
]
}
}
EDIT: No, that didn't work it still exported the entire set of pages. Here's the format that actually works
{
format: "PDF",
powerBIReportConfiguration:{pages:[{pageName:"ReportSection59a3330f95669ad473e6"},{pageName:"ReportSectionc587b2defc60bdd51b80"}]}
}
So you were pretty close 🙂
Yes, the call expects a different format
Specify the pages you want to print according to the Get Pages or Get Pages in Group return value. You can also specify the order of the pages you're exporting.
Thanks @lbendlin but do you have an example of the syntax? I see that reference to Get Pages but not sure how to translate that to a JSON body in an HTTP call. Thanks!
You take the output of Getpages and modify it as needed.
{
format: "PDF",
powerBIReportConfiguration:{"value": [
{
"Name": "ReportSection59a3330f95669ad473e6",
"displayName": "1 Summary",
"order": 0
},
{
"Name": "ReportSectionc587b2defc60bdd51b80",
"displayName": "2 Weekly FY20Q3",
"order": 1
}
]
}
}
EDIT: No, that didn't work it still exported the entire set of pages. Here's the format that actually works
{
format: "PDF",
powerBIReportConfiguration:{pages:[{pageName:"ReportSection59a3330f95669ad473e6"},{pageName:"ReportSectionc587b2defc60bdd51b80"}]}
}
So you were pretty close 🙂
That worked! I was almost there! Thanks again!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 |