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.