Handle https call result which is larger than gateway capacity.

[walid140891]

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!

[v-stephen-msft]

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]

Hello @v-stephen-msft, ,

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!!