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

   

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

   

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

   

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

   

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

   

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

   

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

   

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

    

11. Close and Apply the results

    

12. 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