Solved: Re: ExportTo REST API PDF fails to render visuals ...

Farzad1117 · ‎01-08-2026

I am using the ExportTo REST API to generate PDFs from a Power BI report hosted in a Premium/Fabric workspace.

Scenario

The report uses a DirectQuery dataset.

When exporting via the REST API (PDF), the PDF is generated, but all visuals are empty

Questions

Is this a known DirectQuery limitation for the ExportTo API?

Are there any official references/documentation confirming this behavior?

What is the recommended approach to reliably export PDFs from DirectQuery report

Additional Info:

I am using Python with MSAL for authentication.

Workspace is in Premium/Fabric capacity

Poojara_D12 · ‎01-09-2026

Hi @Farzad1117

This is a known and by-design limitation: the ExportTo (PDF / image) REST API does not support DirectQuery datasets, so when the service tries to render the report in the background export engine it cannot execute the live queries and you get a “successful” PDF with blank visuals. This is documented in Microsoft’s ExportTo and paginated report docs where DirectQuery and some live connections are explicitly excluded from background export and rendering. The only reliable ways to generate PDFs from DirectQuery data today are to use Paginated Reports (RDL) against the same source, or switch the semantic model to Import or Hybrid (with cached tables) so the export engine can read data without opening live connections. If you must keep DirectQuery for interactive reports, the standard pattern is a separate Import/Hybrid model or paginated report purely for exports and automation.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

View solution in original post

Poojara_D12 · ‎01-09-2026

Hi @Farzad1117

This is a known and by-design limitation: the ExportTo (PDF / image) REST API does not support DirectQuery datasets, so when the service tries to render the report in the background export engine it cannot execute the live queries and you get a “successful” PDF with blank visuals. This is documented in Microsoft’s ExportTo and paginated report docs where DirectQuery and some live connections are explicitly excluded from background export and rendering. The only reliable ways to generate PDFs from DirectQuery data today are to use Paginated Reports (RDL) against the same source, or switch the semantic model to Import or Hybrid (with cached tables) so the export engine can read data without opening live connections. If you must keep DirectQuery for interactive reports, the standard pattern is a separate Import/Hybrid model or paginated report purely for exports and automation.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

lbendlin · ‎01-08-2026

Your visuals are rendering too slowly. Make them render faster.

tayloramy · ‎01-08-2026

Hi @Farzad1117,

What happens if you generate a second PDF right after the first one?

I've noticed that when using directlake models, the first export is usually old data/empty and then the second export works as expected. Perhaps that is also an issue with directQuery?

When calling the API, are you using any filters at all?

If you found this helpful, consider giving some Kudos.
If I answered your question or solved your problem, mark this post as the solution!

Proud to be a Super User!