Forum Discussion

martijnkuiper's avatar
martijnkuiper
Frequent Visitor
1 year ago
Solved

Power BI REST API ExportTo MHTML leads to a base64 encoded file

I am using a Python Notebook to export Paginated Reports to an HTML file. Now it works fine for CSV files, I get clear and readable CSV back, the same goes for IMAGE with the format set to PNG. But w...
APIS and Embedding
  • lbendlin's avatar
    lbendlin
    1 year ago

    Ok, plan B.  Use Power Query to decode the Base64 data.  Text.FromBinary(Binary.FromText(payload),Encoding.Base64)

martijnkuiper's avatar
martijnkuiper
Frequent Visitor
1 year ago

Unfortunately this has had no effect for me. Adding the Accept text/html didn't change anything for me. I then switched it up, following your documentation, to */*:

 

But this also didn't lead to a different outcome

lbendlin's avatar
lbendlin
Super User
1 year ago

Ok, plan B.  Use Power Query to decode the Base64 data.  Text.FromBinary(Binary.FromText(payload),Encoding.Base64)

  • martijnkuiper's avatar
    martijnkuiper
    Frequent Visitor
    1 year ago

    I in stead used Python base64 library (since moving in PowerQuery within my script would be quite some redesign) and I now get the same HTML content as I am getting when I export the paginated report to HTML from the browser view.

     

    I can't imagine this is working as intended, but I at least now have an HTML file!