Data Not Loading Into Power BI API Web Connector

Hi Griggs 

I found that, in order for Power BI to parse the URL when published, I had to give it a full, working URL first and apply the variables as a query afterward – rather than hard coding the variables into the URL.

I think you're talking about the dynamic data source error when trying to refresh a web query in the service. This happens when you use a parameterized url string that isnt using the relative path option of Web.Contents. The parameterized URL string below will not refresh in the service.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjXSMzVS0lEyNNYzMQTSRgZGproGhrqGxkgcI3MgpyQ1tyC1KLGktCg13ihXKTYWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [latitude = _t, longitude = _t, startdate = _t, enddate = _t, hourly = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Json.Document( Web.Contents(
"https://archive-api.open-meteo.com/v1/archive?latitude=" & [latitude] & "&longitude="& [longitude] &"&start_date=2025-01-13&end_date=" & [enddate] &  "&hourly=" & [hourly],  [Headers = [#"Accept-Encoding" = "gzip"]])) )
in
    #"Added Custom"

I expected the query below to refresh in the service as it did in the past but it appears an updateto  the service engine now invalidates this approach. Notice that I placed all parameters inside relativepath

let
    latitude = [latitude],
    longitude = [longitude],
    startdate = "2025-01-13",
    enddate = [enddate],
    hourly = [hourly],

    // Define the relative path with parameters
    relativePath = "/v1/archive?latitude=" & latitude & "&longitude=" & longitude & "&start_date=" & startdate & "&end_date=" & enddate & "&hourly=" & hourly,

    // Fetch data using Web.Contents with relative path and Accept-Encoding gzip
    Source = Json.Document(Web.Contents("https://archive-api.open-meteo.com" & relativePath, [
        Headers = [#"Accept-Encoding" = "gzip"]
    ]))
in
    Source

The query below uses relative path for the base url and the parameters are inside Query = [...]. This will refresh in the service. You can confirm that by going to datasource settings. You shouldn't be seeing this warning:

 

let
    latitude = [latitude],
    longitude = [longitude],
    startdate = [startdate],
    enddate = [enddate],
    hourly = [hourly],

    // Define the relative path and query parameters
    relativePath = "v1/archive",

    // Fetch data using Web.Contents with RelativePath and Accept-Encoding gzip
    Source = Json.Document(Web.Contents("https://archive-api.open-meteo.com", [
        RelativePath = relativePath,
        Query = [
            latitude = latitude,
            longitude = longitude,
            start_date = startdate,
            end_date = enddate,
            hourly = hourly
        ],
        Headers = [#"Accept-Encoding" = "gzip"]
    ]))
in
    Source

 

 

Here's the full working query

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjXSMzVS0lEyNNYzMQTSRgZGproGhrqGxkgcI3MgpyQ1tyC1KLGktCg13ihXKTYWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [latitude = _t, longitude = _t, startdate = _t, enddate = _t, hourly = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each let
    latitude = [latitude],
    longitude = [longitude],
    startdate = [startdate],
    enddate = [enddate],
    hourly = [hourly],

    // Define the relative path and query parameters
    relativePath = "v1/archive",

    // Fetch data using Web.Contents with RelativePath and Accept-Encoding gzip
    Source = Json.Document(Web.Contents("https://archive-api.open-meteo.com", [
        RelativePath = relativePath,
        Query = [
            latitude = latitude,
            longitude = longitude,
            start_date = startdate,
            end_date = enddate,
            hourly = hourly
        ],
        Headers = [#"Accept-Encoding" = "gzip"]
    ]))
in
    Source),
    #"Expanded Custom" = Table.ExpandRecordColumn(#"Added Custom", "Custom", {"latitude", "longitude", "generationtime_ms", "utc_offset_seconds", "timezone", "timezone_abbreviation", "elevation", "hourly_units", "hourly"}, {"latitude.1", "longitude.1", "generationtime_ms", "utc_offset_seconds", "timezone", "timezone_abbreviation", "elevation", "hourly_units", "hourly.1"})
in
    #"Expanded Custom"

 

 

Hi Griggs 

 

Have you made any changes to your query code?

 

There are several discussions in the Microsoft Fabric Community forums where users have faced similar issues for your reference:

Solved: PowerBI: Refresh is stuck on "evaluating" - Microsoft Fabric Community

Solved: How to avoid pbi evaluating take very long - Microsoft Fabric Community

 

Given I have so little information at this time, I can't tell what's causing your problem.You can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support:  https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thank you for your understanding.

 

Best Regards

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