Power BI feed
Hosted snapshot feed for Power BI — the pipeline keeps a current-values table up to date; Power BI reads it via Get Data → Web.
What it does
What you'll need to set it up
This becomes the feed's web address: Power BI will read from /api/feed/‹slug›. Pick something recognisable — lowercase letters, numbers and hyphens only.
The password Power BI presents to read this feed. Leave blank and a strong one is generated for you (shown on the Feed tab after saving). It only unlocks this feed's chosen fields — never your WFX login.
Where does the data live? "Live": each Power BI refresh reads WFX at that moment and the data passes straight through — nothing is ever stored on our servers, but a refresh can take a minute or two and is limited to once per dataset interval (set per pipeline). "Cached": we keep an encrypted copy of just your chosen fields, updated on each pipeline's schedule — refreshes are instant and unlimited; better for very large catalogues or many simultaneous viewers. If data custody matters to your business, choose Live.
Normally the consumer key travels in a hidden request header. Turning this on ALSO accepts it inside the web address itself — easier for some tools, but addresses end up in logs and browser history. Leave off unless the Power BI service refuses header auth on scheduled refresh.
Technical reference — endpoints
| Operation | Direction | Call |
|---|---|---|
| Snapshot feed (consumer GETs /api/feed/{slug}) | Write (target) | /api/feed/{slug} |
Set it up inside Smart Data Studio in a few minutes.