Power BI reads your account's data through a ready OData feed, so your internal reports refresh on their own.
Steps
- Create a key in data connections with the datasets you want.
- In Power BI Desktop: Home, Get data, OData feed.
- Paste the feed link shown on the data connections page, and choose Basic authentication.
- User name: any word (such as powerbi). Password: the key.
- Pick the tables and Load. In the Power BI service, set scheduled refresh with the same credentials.
Common questions
- What period does it read? The last year by default; the time field can be filtered.
- Refresh stopped. Check the key is not revoked and the account is active, and look at the call log.
Was this page helpful?
Didn't find what you need? Contact us