Skip to main content

Power BI Connector

Connect your Xemelgo data to Power BI in a few steps. No third-party connector required — Power BI's built-in Web connector handles everything.


Step 1 — Configure Privacy Settings​

Power BI's default privacy settings can block API requests and cause a Formula.Firewall error. Disable them once before doing anything else.

  1. Click File → Options and settings → Options
  2. Under Global, select Privacy
  3. Under Privacy Levels, select Always ignore Privacy Level settings
  4. Click OK

Step 2 — Open Power Query Editor​

  1. Open Power BI Desktop
  2. Click Home → Transform data → Transform data

Step 3 — Create a Blank Query​

  1. In the Power Query Editor, click New Source → Blank Query
  2. Right-click the new query in the left panel → Advanced Editor

Step 4 — Paste the Query Code​

Pick a connector from the table below, go to its page, and copy the M Query code. Paste it into the Advanced Editor.


Step 5 — Enter Your Credentials​

At the top of the pasted code you will see:

Email    = Binary.ToText(Text.ToBinary("your@email.com",   TextEncoding.Utf8), BinaryEncoding.Base64),
Password = Binary.ToText(Text.ToBinary("YourPassword123!", TextEncoding.Utf8), BinaryEncoding.Base64),

Replace your@email.com and YourPassword123! with your Xemelgo email and password. That's it — the query base64-encodes them automatically, as the API requires.

Click Done, then rename the query to something meaningful (e.g., Xemelgo Assets).


Available Connectors​

ConnectorWhat You Get
AssetsAll assets with location, type, and custom fields
Asset TypesAsset type catalog; on-hand counts by location
ContainersContainers with contents and current location
Container TypesContainer type catalog
InventoryInventory items with part details, location, and state
Item TypesItem type catalog; on-hand/missing/overdue counts by location
LocationsLocations, customers, roles, and categories
Transfer OrdersAsset, inventory, and package transfer orders
Work OrdersWork orders with location and state counts
Some queries require additional features

Certain queries (such as item type counts by location) require specific features to be enabled on your Xemelgo account. If you get a "cannot apply field access to the type Null" error, that query is not available for your tenant — contact Xemelgo support to confirm which features are active.