Skip to content
Ask the community about this page

Publish a Timextender Data Enrichment table to PowerBI with REST API

In this article, you will learn how to Publish an exMonDM table to PowerBI with REST API.

  1. To publish an exMonDM table to PowerBI you start by sharing your table by clicking the advanced tab and selecting Share

Publish a Timextender Data Enrichment table to PowerBI with REST API — screenshot 1

  1. Copy this link.
  2. Open PowerBI
  3. Select File → Get data → Web

Publish a Timextender Data Enrichment table to PowerBI with REST API — screenshot 2

  1. Paste your link from step 2 into the popup dialog and click OK

Publish a Timextender Data Enrichment table to PowerBI with REST API — screenshot 3

  1. Double click on the *.exMonDM.com link

Publish a Timextender Data Enrichment table to PowerBI with REST API — screenshot 4

  1. Right-click the Column1 header, select Transform and transform the data to JSON

Publish a Timextender Data Enrichment table to PowerBI with REST API — screenshot 5

  1. Select the first record, switch to the Transform tab and select Convert To List

Publish a Timextender Data Enrichment table to PowerBI with REST API — screenshot 6

  1. Select the To Table button and Press OK in the popup

Publish a Timextender Data Enrichment table to PowerBI with REST API — screenshot 7

  1. Split the Records into separate columns by pressing the button on the right side of the header

    Publish a Timextender Data Enrichment table to PowerBI with REST API — screenshot 8

  2. Close and Apply the results

    Publish a Timextender Data Enrichment table to PowerBI with REST API — screenshot 9

  3. Now you can schedule to refresh the data source and start creating your PowerBI report. Remember to convert your columns to the correct Data Types

Discussed in the community

Looking for related questions…

Didn't find your answer? Ask the community about this page — questions are answered by Timextender experts, partners and other users.