Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
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.
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!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.