Skip to main content

Publish an exMonDM table to PowerBI with REST API

  • 5 April 2024
  • 2 replies
  • 76 views

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

Where can we find the "advanced" tab? I cannot see it in the portal nor the exmon dg desktop application. 

Hi Sven,
This article is referring to Master Data Management, not DG. That is a separate client which you can read about here.
This is what is being referred here:

 

Reply


Terms and ConditionsCookie settings