Exporting Paginated Report to excel, pdf, and json using Power BI API, with parameters passed

Thank you, I was able to export the report prior to this post but it very similar to how I was able to export.

At first I had created a Paginated Report in Power BI Service, this is the report I was using to test this export. The report created in Power BI Service was able to download and export when it had no parameters. After adding parameters to that same report and trying to export it I was unable to.

Given another Paginated Report that was developed with Power BI Report Builder, with defined parameters, I was able to export the report.

Maybe a bug, but parameters are not recognized by the Power BI REST API given that the pagniated report and parameters were created using Power BI Service and not Power BI Report Builder.

Thank you for the help, but I already tried this and getting the same response. 

To give more context this is what I am starting with:
access_token is from API that is already added as a member to a Premium Per User Workspace

export_url = f'https://api.powerbi.com/v1.0/myorg/groups/{group_id}/reports/{report_id}/ExportTo'

headers = {
            'Content-Type': 'application/json',
            'Authorization': f'Bearer {access_token}'
          }

parameters = [
{"name": "Department", "value": "dep_name"}
]

export_data = {
      "format": "XLSX",
      "paginatedReportConfiguration": {
        "parametersValues": parameters
}
}

 

 

My export function that will post export request, verify the request, then start the export.

def export_report():
    response = requests.post(export_url, headers=headers, json=export_data)

    if response.status_code == 202:
        print('Export request accepted, waiting for completion...')
        
        
        status_url = response.headers['Location']
        
        while True:
            status_response = requests.get(status_url, headers=headers)
            
            if status_response.status_code == 200:
                
                export_status = status_response.json()
                for k, v in export_status.items():
                        print(f'{k}, {v}')

                if export_status['status'] == 'Succeeded' and export_status['percentComplete'] == 100:
                    
                    resource_location = export_status['resourceLocation']
                    file_response = requests.get(resource_location, headers=headers)
                    
                    if file_response.status_code == 200:
                        with open(f'file_export_test{export_status["resourceFileExtension"]}', 'wb') as file:
                            file.write(file_response.content)
                        print('Report downloaded successfully!')
                        return
                    
                    else:
                        print(f'Failed to download report: {file_response.status_code}')
                        return
                    
                # Export Fails    
                return
            
            
            
            elif status_response.status_code == 202:
                print('Export still in progress, waiting...')
                time.sleep(10)  # Wait for 10 seconds before checking again
           
           
            else:
                print(f'Failed to export report: {status_response.status_code}')
                break
    
    
    
    elif response.status_code == 429:
        retry_after = int(response.headers.get('Retry-After', 60))  # Default to 60 seconds if header is missing
        print(f'Too many requests. Retrying after {retry_after} seconds...')
        time.sleep(retry_after)
        export_report()  # Retry the export
    
    
    else:
        print(f'Failed to initiate export: {response.status_code}')

export_report()