Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Getting Payload from Mulesoft Aggregated Metrics API in Power BI through Power BI Connector

Hi All,

 

I am trying to get the Output Payload from Metrics Tool Kit API (which is an Aggregator API created in Mulesoft for Splunk Dashboard), transformed and transmitted to Power BI Workspace. I want to have the Data Refreshed in Power BI Workspace at the same time frame when it updates the data for Splunk Dashboard.

 

Currently we have the data from the Metrics Tool Kit API sent to Splunk every 6 hours.

 

Need help and Guidance, as i am Novice to both Mulesoft as well as to Power BI

 

Regards;

Anandh Madhavan

+1 704.425.4307

1 REPLY 1
jaweher899
Super User
Super User

Here are the general steps you can follow to get the data from the Metrics Tool Kit API into Power BI:

  1. Connect to the Metrics Tool Kit API from Power BI: In Power BI Desktop, select "Get Data" from the Home ribbon and choose "API" as the data source. Enter the API URL for the Metrics Tool Kit API and configure the authentication method (if necessary).

  2. Transform the data: After connecting to the API, you may need to transform the data to fit your reporting requirements. You can do this using the Power BI Query Editor by cleaning, transforming, and shaping the data.

  3. Load the data into Power BI Workspace: After transforming the data, you can load it into Power BI Workspace by selecting "Close & Apply" in the Power BI Query Editor.

  4. Set up data refresh: In the Power BI Workspace, go to the "Settings" menu and select "Datasets". Find your dataset in the list and select the "Refresh" option. Configure the refresh schedule to match the update frequency of the Metrics Tool Kit API (every 6 hours).

Note: If the Metrics Tool Kit API requires an API key or other form of authentication, you will need to set this up in Power BI before connecting to the API.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors