Catalog

Power BI

Load a dataset into a report.

How Power BI loads data

Power BI treats an outside API as a web data source. After you connect, the result becomes a table you can refresh. Scheduled refresh in the Power BI service keeps using the same URL and header.

Connect

  1. Open Power BI Desktop. Keep your API key from the order confirmation (mk_…) and your dataset id from the catalog or confirmation email ready, for example B-026.
  2. Home → Get data → Web.
  3. Choose Advanced.
  4. Paste the CSV endpoint and the Authorization header (replace dataset id and key):

    Copy these two values:

    https://data-marketplace-data.bakosbence.com/v1/data/B-026?format=csv
    Authorization
Bearer mk_…

    There is a space after Bearer. No quotes.

  5. When asked how to sign in, choose Anonymous. Then Connect. (If you pick another method, Power BI may ignore your header and you get 401.)
  6. If it asks for file type, choose CSV.
  7. Load. Or Transform data if you want to split columns first.

Visit Microsoft’s Web connector for more information.

If it fails

  • 401 — key missing, mistyped, or you did not choose Anonymous.
  • 403 — that dataset is not in your access, or access expired.
  • 404 — access is valid, but no scrape is ready yet.

To list the datasets on your key: same steps with URL https://data-marketplace-data.bakosbence.com/v1/sites.

Support

Any questions?

Email info@bakosbence.com.

Please write from a company-specific email address, or include an order identifier you received in email. Include the endpoint or the dataset you have a problem with.

Catalog