Forum Discussion

walid140891's avatar
walid140891
Helper III
3 years ago

Handle https call result which is larger than gateway capacity.

Hello Power BI Pros,

We call an azure function url via Web.Contents() method as following:

 

 

let
    Source = (CustomerGuid as text) => let
       Source = Json.Document(
           Web.Contents(
               "http://powebidatarefresh.azurewebsites.net/api/PBIRefreshFunction/Run/",
               [RelativePath = CustomerGuid] 
               )
        ) in Source
in
    Source

 

 

It workes very well but when I chose a bigger data set to refresh I face this error in power bi desktop:

 


It looks like the result coming from the http call is bigger that the gateway capacity.
Is there a workaround or a way to handle this issue, for example by chunking the data or paginate it or enlarging the gateway!

Thank you for your support!

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi walid140891 ,

     

    Have you trid to create a brand new Power BI file and connect it again?

    If possible, go to Data Source Settings to remove the added data source credentials before recreating the Power BI file.

     

     

    Best Regards,

    Stephen Tao

     

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

    • walid140891's avatar
      walid140891
      Helper III
      3 years ago

      Hello Anonymous, ,

      Thank you for your response, I tried your suggestion and it worked when I called the http azure function URL, but when I add the rest of the tables (so many tables based on the first one created by the call) I receive the same error: 502 badgateway and sometimes 500!!