How to download/export PowerBI report .PBIX file from PBI service using REST API in Python?

[pbi_sujay]

I am able to download .pbix file from PBI service using powershell Invoke-PowerBIRestMethod rest api please find below runnable code

$ApiUrl = "https://api.powerbi.com/v1.0/$groupsPath/reports/$reportId/Export"

#Export power BI file to current directory
$export_id = Invoke-PowerBIRestMethod -Url $ApiUrl -Headers $auth_header -Method GET -ContentType "application/zip" -OutFile $filePath -TimeoutSec 0 -Verbose

But unable to process this in python. Can you help here for missing paramter or what I am missing.
While converting into python Im using below code:

Target URL: The target API is GET - https://api.powerbi.com/v1.0/myorg/groups/$reportId/reports/$groupId/Export

Header: { Authorization: bearer 'access_tocken', Content-Type: application/zip}

[V-lianl-msft · Accepted solution]

Hi @pbi_sujay ,

You can refer to the sample:

https://github.com/cmberryau/pypowerbi/blob/master/pypowerbi/reports.py 

For more details,you can refer to this blog:

https://www.datalineo.com/post/power-bi-rest-api-with-python-and-microsoft-authentication-library-ms... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

The spelling is different.  Use Bearer  (capital B)  and no single quotes around the token.

[pbi_sujay]

Hi , Yes we already tried that but it did not work.