Forum Discussion
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...
So in the desktop service i should enter the code for the online service becuase thats where it will end up?
It all depends on your use case. If you eventually plan to run a scheduled refresh of your dataset in the Power BI service then you have to write your Power Query code in the desktop (or in a dataflow) in a way that avoids the formula firewall issues. There are lots of good articles on the interwebs about this topic.
