Forum Discussion

db190Coding's avatar
db190Coding
Regular Visitor
4 years ago
Solved

Export Report in Group Timeout (500), but Forbidden Error (403) when using preferClientRouting=true

Hi together,   I'm trying to built a Python application, which first downloads the .pbix file from power BI Service and later refreshes the dataset, so that I can implment a automated snapshot and ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi db190Coding ,

     

    Please check the offical blog to get more information about how to troubleshooting when API call returning 403.

    For reference: API call returning 403

    What is the capacity of the workspace where your report is located, Shared Capacity or Premium Capacity? 

    I checked an know issue with similar problem that when using Export to File REST API, API call returns a 500. 

    Its workaround is moving the workspace to Premium Gen2.

     

    Best Regards,
    Rico Zhou

     

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

You should be getting a 307, not a 403. 

 

"If your request arrives at the wrong cluster, the Power BI service returns a 307 Temporary Redirect HTTP response. In such cases, you need to redirect your request to the new address specified in the response HTTPS Location header."

 

Does your request work if you don't ask for the routing?

  • db190Coding's avatar
    db190Coding
    Regular Visitor
    4 years ago

    Hi and thanks a lot for your support. Yes, without the Parameter, the request works, but in case of the Download of this pbix file, which has about 300 MB times out with response Code 500 after some time. For smaller files (I tested with a 90 MB file) it works without any issue.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi db190Coding ,

       

      Please check the offical blog to get more information about how to troubleshooting when API call returning 403.

      For reference: API call returning 403

      What is the capacity of the workspace where your report is located, Shared Capacity or Premium Capacity? 

      I checked an know issue with similar problem that when using Export to File REST API, API call returns a 500. 

      Its workaround is moving the workspace to Premium Gen2.

       

      Best Regards,
      Rico Zhou

       

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

      • fariayakhan's avatar
        fariayakhan
        Regular Visitor
        3 years ago

        Hi db190Coding,

         

        I am facing the same issue as well. Were you able to resolve this issue? 

        Anonymous My workspace is location in a premium capacity.

        I have also raised a ticket for this but we have not been able to resolve this issue yet

         

        Thanks & Regards,

        Faria