Forum Discussion

SebbyP333's avatar
SebbyP333
Helper I
4 years ago
Solved

How to use an API string with reference to a dynamic table column?

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 url in red, bold and underlined is the stock code a...
Need Help
Tips and Tricks
parry2k's avatar
parry2k
Super User
4 years ago

SebbyP333 solution attached. 

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

  • SebbyP333's avatar
    SebbyP333
    Helper I
    4 years ago

    Thank you but I am trying to reference a column in a seperate table.  Please find attached your file Stock API 

    with a table called Ticker Universe.  I want to reference the column 'Ticker Universe', 'EOD Stock Code'.  The reason being is that this is imported from another file which gets maintatined outside of Power BI.

     

    I have uploaded to Power BI online service.  This dynamic design doesn't allow for scheduled refresh.  Is there another solution possible to create the API URL and being able to schedule refresh online?

  • Wolly's avatar
    Wolly
    Helper I
    2 years ago

    I'm trying to incorporate this solution as well for a basket of stocks.  I keep getting the error "Expression.Error: The import Changed Type matches no exports. Did you miss a module reference?" when i put my own stock tickers in in place of the McDonalds etc.  What could i be missing?  Thx for the help!