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.
- Click File → Options and settings → Options
- Under Global, select Privacy
- Under Privacy Levels, select Always ignore Privacy Level settings
- Click OK
Step 2 — Open Power Query Editor
- Open Power BI Desktop
- Click Home → Transform data → Transform data
Step 3 — Create a Blank Query
- In the Power Query Editor, click New Source → Blank Query
- 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
| Connector | What You Get |
|---|---|
| Assets | All assets with location, type, and custom fields |
| Asset Types | Asset type catalog; on-hand counts by location |
| Containers | Containers with contents and current location |
| Container Types | Container type catalog |
| Inventory | Inventory items with part details, location, and state |
| Item Types | Item type catalog; on-hand/missing/overdue counts by location |
| Locations | Locations, customers, roles, and categories |
| Transfer Orders | Asset, inventory, and package transfer orders |
| Work Orders | Work orders with location and state counts |
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.