How to Connect Power BI to Mingo

Get the information from Mingo and use Power BI to display the Information

Video

Process

1. Open Power BI and select the Get Data Option from the popup screen.
   If this is not an option, you can find the Get Data option in the Home Tab
   
2. [Click] on the search bar, and type blank. Select the option Blank Query, and [click] Connect.
   
3. Right [click] on the Query, you just created, and select Advance Editor. 
   
4. Delete the highlighted quotation marks on the popup screen.
   
5. Type or paste the following after the equal sign:
                          Json.Document(Web.Contents(""))
   
6. Get to the URL located on your API. While you are logged into your Mingo Account, open a separate window and paste the URL to access your API "https://api.gomingo.io".
7. On the API, go to the "Sample Production Query" to get the URL for your request
   
8. Update the date of extraction, you do so by finding the following piece of the code "gte&filter[filters][0][filters][0][value]=2022-03-06" and changing it to end date you would like.
   
   The date when this was done was 11/16/2022. As you can see, I decided to use yesterday for my data.
9. Write the following after the "Sample Production Query":
                 , [Headers= [Authorization=""]]
   
10. Instructions on how to find the API Key are in the following documentation (https://support.gomingo.io/machine-data-collection). 
11. Power Bi would ask you to confirm your credentials. [Click] on Edit Credentials. A popup will show, [click] Connect. 
    
12. Change the number of records you would obtain by updating the number "25" to the amount needed.
    
13. When completed, convert the query into a table. [Click] on Into Table.
    
14. To see how to Expand and Rename the Columns. Please review the video at the beginning of the article.