Forum Discussion

michaelsh's avatar
michaelsh
Kudo Kingpin
5 years ago
Solved

Dynamic Base URL with prefix for API calls - Power Query

Hello friends, I've built a function that calls API, parses the json results and loads to a table in Power BI. = Json.Document(Web.Contents(pBaseURL, [RelativePath="/v1/students", Headers=[#"Author...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    You can't.  The beginning part of a dynamic URL needs to be static. 🙂  Your URL schema is unsuitable for consumption by Power BI.

michaelsh's avatar
michaelsh
Kudo Kingpin
5 years ago

Thanks, lbendlin 

I would rather think of it this way:

Power BI is not yet suitable for consuming my URL schema...

🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hey,

     

    I'm facing the similar problem, have you had any solution to it (or adapted scheme)?