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 when I set the format to MHTML as per the documentation I am getting a long error response about my headers, followed by a succesfull download of a file with .html extension. If I open it however it doesn't look like HTML: MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_01C35DB7.4B204430" X-MSSQLRS-ProducerVersion: V This is a multi-part message in MIME format. ------=_NextPart_01C35DB7.4B204430 Content-ID: <filename> Content-Disposition: inline; filename="filename" Content-Type: text/html; name="filename"; charset="utf-8" Content-Transfer-Encoding: base64 PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMDEgVHJhbnNpdGlvbmFs aXB0LVR5cGUiIGNvbnRlbnQ9InRleHQvamF2YXNjcmlwdCIvPjxNRVRBIEhUVFAtRVFVSVY9Ikxv....[this goes on for a long time] VEg9IjAiIEhFSUdIVD0iMTAwJSI+PC9URD48L1RSPjwvVEFCTEU+PC9ESVY+PC9ESVY+PC9ib2R5 PjwvaHRtbD4= ------=_NextPart_01C35DB7.4B204430-- I have tried several bodies, but the documentation is lacking for the formatSettings for Paginated Reports: And with empty formatSettings and I also left the formatSettings completely out, but there is no difference. The response from the download action for this html file is as follows: Failed to parse headers (url=https://api.powerbi.com:443/v1.0/myorg/groups/[REDACTED]/reports/[REDACTED]/exports/Mi9CbG9iSWRWMi1mYTJjOTY5Yy00NmZlLTRiYzktYjNkZS00NjFmZTE1YmExMTN3UHY3ZGxOLXlXVXpxU3N2THlGWk5YMlN2Yzl4MnRQeUJaWk4tQ2x0Lg==/file😞 [NoBoundaryInMultipartDefect()], unparsed data: '' Traceback (most recent call last): File "/home/trusted-service-user/cluster-env/trident_env/lib/python3.11/site-packages/urllib3/connection.py", line 464, in getresponse assert_header_parsing(httplib_response.msg) File "/home/trusted-service-user/cluster-env/trident_env/lib/python3.11/site-packages/urllib3/util/response.py", line 88, in assert_header_parsing raise HeaderParsingError(defects=defects, unparsed_data=unparsed_data) urllib3.exceptions.HeaderParsingError: [NoBoundaryInMultipartDefect()], unparsed data: '' And the file itself remains unreadable base64 encoded and it seems to be partial. Now I have a hunch that there maybe is a formatSetting to get a UTF-8 / UTF-16 HTML file, but it also seems odd that that would have to be specified. How can I find out why my HTML file is not properly formatted as readable (and usable) HTML? Adding just ?rdl:format=MHTML to a URL of a Paginated Report returns a readable HTML file. But when using the REST API, I cannot find why it keeps sending me base64 encoded partial files. Thanks for helping me out Martijn Kuiper
Web.Contents with the Content option is only supported when connecting anonymously.
Hello All, I am connecting to api using basic token. but I am getting the authentication issue which is "Web.Contents with the Content option is only supported when connecting anonymously." i Knew it is very common error and gone thorugh all the below links https://community.powerbi.com/t5/Service/Anonymous-access/m-p/21014#M5916 http://community.powerbi.com/t5/Developer/Using-a-REST-API-as-a-data-source-Web-Contents-Content-option/m-p/115650#M4042 http://community.powerbi.com/t5/Service/Cannot-sign-in-with-Anonymous-Authentication-for-a-Web-API/td-p/168154?lightbox-message-images-168154=39597iD83266D92D25D020 the power Query is let AuthKey = "Basic mytoken", url="https://tfs.mnsu.edu/tfs/ITS%20AppDev/Test%20Agile%20Project/_apis/wit/wiql?api-version=1.0", body="{ ""query"": ""Select [System.Id], [System.Title], [System.State] From WorkItems Where [System.WorkItemType] = 'Task' and [System.AreaPath]='Test Agile Project'"" }", Source = Json.Document(Web.Contents(url,[ Headers = [#"Authorization"=AuthKey , #"Content-Type"="application/json"], Content = Text.ToBinary(body) ] )) in Source and error i am getting is can anyone please hemp
Multiple Embedded Dashboards with Login Via Website
Hey All I was wondering if there was anyone who had insights into embedding Power BI dashboards but the access to them would be done from them going through a Login Page on our website the then take them to a landing page with all the dashboards we have developed for them. I am looking at different platforms to use as I have spent much of my time with both Power BI and Tableau but also checking others out like Metabase etc. We are developing linkages to our clients data and creating the datamodel etc that backs up their dashboards but i want a seamless experience for them in relation to the dashboards so that its just 1 login via our website to then have the single sign on end up on a landing page with the dashboards we have created for them. Plus have it stylsed in our brand for the landing page etc Ive seen quite a bit about embedding individual dashboards but cant find much or clear guidance on what I am looking to achieve Cheers
PowerBI Report integration - Dataset ID missing for Paginated Report
Hi Everyone, We have successfully integrated PowerBI reports into our Java Web Application, and the reports are rendered on the webpage without issues. However, for reports of type "PaginatedReport," we encounter a problem. The DatasetID is missing in the Get Report Endpoint (https://api.powerbi.com/v1.0/myorg/groups/<Sample-ID>/reports/<Report-ID>), which prevents us from obtaining the EmbedToken and causes the entire report rendering process to fail. Is there a way to generate an EmbedToken without the DatasetID? Please advise.
