Publish an exMonDM table to PowerBI with REST API

Created by: Gunnar Tómas Gunnarsson

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

Gunnar is the author of this solution article.