This dataset includes a dynamic data source. Shipstation API

[jbrown184]

Hey I am having issues. This is the error I am getting. Below is my current query. I need help!

[Anonymous]

Hi @jbrown184 ,

Could you please tell us that if your issue has been solved? I reviewed this post and I think the workaround from danextian is great.

If you still have doubts, feel free to ask here.

Best Regards,

Stephen Tao

[jbrown184]

Hey I am having issues. This is the error I am getting. Below is my current query. I need help!

[jbrown184]

HI! I did what you said. I made a paramater. When I go back to powerbi.com it still says "

This dataset includes a dynamic data source". Here is what I did....

[danextian]

Hi @jbrown184 

That is expected as you are using a url string from concatenating  using different text strings. Use relative property of web.contents. Examples:

let
    BaseUrl = "https://www.baseurl.com",
    PageSize = 500,
    Page = [page column],
    RelativePath = Text.Combine({"/orders?pageSize=", Text.From(PageSize), "&page=", Text.From(Page)}),
    AuthorizationKey = "Basic " & "actual key",  --key could be parameterized
    Response = Web.Contents(BaseUrl, 
        [
            RelativePath = RelativePath, 
            Headers = [Authorization = AuthorizationKey]
        ]
    ),
    Data = Json.Document(Response)
in
    Data

let
    PageSize = 500,
    Page = [page column], 
    BaseUrl = "https://www.baseurl.com",
    AuthorizationKey = "Basic yourkey=", // --or use a parameter
    Response = Web.Contents(
        BaseUrl,
        [
            RelativePath = "orders",
            Query = [pageSize = Text.From(PageSize), page = Text.From(Page)],
            Headers = [Authorization = AuthorizationKey]
        ]
    ),
    Data = Json.Document(Response)
in
    Data

Text.From on PageSize and Page is not needed if both are texts.

[jbrown184]

HI! I did what you said. I made a paramater. When I go back to powerbi.com it still says "

This dataset includes a dynamic data source". Here is what I did....

[danextian]

Hi @jbrown184 

Have you already deleted the queries that initially caused the error? Please note that a presence of even just a single query that uses concatenated url strings will keep the error.

[lbendlin]

you didn't completely follow @danextian 's advice. Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1

[jbrown184]

Hey I am having issues. This is the error I am getting. Below is my current query. I need help!

[lbendlin]

screenshots are too small read.  Please repost.

Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1