Web content problem

[manojk_pbi]

Hi,

I have a use case wherein i am extracting data from OData.Feed. This will return me few data fields using which i will have to construct a web link and extract few more data fields. 

In first instance it is working fine and i am connecting using Gateway. For the second part i am getting below error message as the web link is getting created dynamically.

This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.

• Data source for Query1

How can we make it work or is it not possible at all ? The same works fine from desktop.

[Anonymous · Accepted solution]

Hi,@manojk_pbi 

Regarding the issue you raised, my solution is as follows:

1.First of all from what I understand, the best way to target your issue is to use Web.Contents() in powerquary to make code changes against your data source link.

You can modify it in the Advanced Editor option in Powerquary.

Suppose I need the option to retrieve the contents of "https://bing.com/search?q=Power+Query".The following is a code example:

let
    searchText = "Power Query"
in
    Web.Contents(
        "https://www.bing.com",// Web site root directory
        [
            RelativePath = "search",// The part before the question mark.
            Query = [q = searchText]
        ]
    )

Then publish it to the powerbi service again, set the data source, and it will refresh normally.

Here is a link to the relevant documentation:

Web.Contents - PowerQuery M | Microsoft Learn

Troubleshooting the Power Query Web connector - Power Query | Microsoft Learn

2.You can try to create a data source connection on the server using Data Streaming so that you can add and edit data sources and manage data refresh schedules in Cloud Data Streaming, this may help you with your issue, here is a link to the relevant documentation:

Creating a dataflow - Power BI | Microsoft Learn

Data refresh in Power BI - Power BI | Microsoft Learn

Best Regards,

Leroy Lu

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