Forum Discussion

9 Replies

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

     

     

     

     

    • danextian's avatar
      danextian
      Super User

      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's avatar
        jbrown184
        Helper I

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

         

         

    • jbrown184's avatar
      jbrown184
      Helper I

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

       

       

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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    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