Forum Discussion

SebbyP333's avatar
SebbyP333
Helper I
4 years ago

How to reference a table column within an API url

Hello Power BI Forum,   I have the following API url to pull in stock price data using the web function on Power BI Desktop.  The part of the API key in red, bold and underlined is the stock code a...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

This is easy to do on the desktop. You take your list of stock symbols, then add a custom column where you construct the URL for each and call Web.Contents() on that  URL.

 

In the service however you will hit the formula firewall and will have to rewrite the Web.Contents call to use relativepath instead.

 

So - where does it need to work? Desktop is sufficient? 

  • SebbyP333's avatar
    SebbyP333
    Helper I
    4 years ago

    I am building the report in Power BI desktop but once complete i will upload to Power BI service in the App environment.  WIll that cause an issue?

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Yes, it will. The service won't be able to refresh your dataset unless you make the code changes I mentioned.