Paginated Report in Excel or CSV format to Lakehouse?

[JS0309]

Hi,

Is there anyway to use a Notebook to save Paginated Report in Excel or CSV format to Lakehouse?

Thank you

[v-agajavelly]

Hi @JS0309 ,

Yes, it’s possible. As the @tayloramy  mentioned, you can do this in a Fabric Notebook by calling the Power BI Export to File REST API for paginated reports. When you specify XLSX or CSV as the format, the API returns the file contents as bytes. From there, you can.

• Write those bytes into your Lakehouse Files area so they’re available alongside your other data.
• Optionally load the output into a Delta table if you want to query it directly in Fabric.
  
  

Thanks,
Akhil.

[tayloramy · Accepted solution]

Hi @JS0309 ,

Yes. You can automate this with a Fabric Notebook by calling the Power BI “Export to file” REST API for Paginated reports (choose XLSX or CSV) and then writing the returned bytes into your Lakehouse Files area. You can also load the file into a Delta table if needed.

Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

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