Simon Hobman

My feedback

  1. 701 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      29 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
      Simon Hobman supported this idea  · 
    • 47 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        7 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
        Simon Hobman commented  · 

        For Web.Content it looks like there is some support for parameters.

        If the source is:
        Source = Json.Document(Web.Contents("https://data.gov.uk/api/3/action/package_search?q=blah"))

        Just add in a Query option with the parameter, like this:
        Term = "blah",
        Source = Json.Document(Web.Contents("https://data.gov.uk/api/3/action/package_search?q=default", [Query=[q=Term]]))

        In our case our API which I'm trying to hit has params as slugs in the URL itself, which does not seem to be supported yet. e.g. https://our-api.com/{term}/data/stuff

        Reference:
        https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/

        Web.Contents (Query option):
        https://msdn.microsoft.com/en-us/library/mt260892.aspx

        Simon Hobman supported this idea  · 
      • 363 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          37 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
          Simon Hobman supported this idea  · 
        • 396 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            60 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
            Simon Hobman supported this idea  · 
          • 650 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              32 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
              Simon Hobman commented  · 

              Yes please, I need this.

              Simon Hobman supported this idea  · 

            Feedback and Knowledge Base

            Ready to get started?

            Try new features of Power BI today by signing up and learn more about our powerful suite of apps.