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