Viewing data in Microsoft BI

In this guide we'll look at how to import your data into Microsoft Power BI  which can further increase your insight of data stored in Tadabase. 

 

To start make sure you download Power BI (Download Link) and follow the steps to install and activate. 

 

In your Power BI project, under Get Data select Blank Query

plsv7HJRJSn3KOGzrIEKJtmP5wRG0KAVkQ.png

 

 

Once the Power Query Editor opens up, right-click on the new query to open up the Advanced Editor.

 

 

Next copy and paste the code below and be sure to replace the 4 values with your own API credentials and table ID. If you're not sure how to access that, please see our API support doc. 

let
     apiUrl = "https://api.tadabase.io/api/v1/data-tables/<REPLACE-WITH-YOUR-TABLE-ID>/records/",
     options = [Headers =[
          #"X-Tadabase-App-Key"= "<REPALCE WITH YOUR APP KEY>", 
          #"X-Tadabase-App-Secret"= "<REPLACE WITH YOUR APP SECRET >",
          #"X-Tadabase-App-id"="<REPLACE WITH YOUR APP ID>"
          ]
          ],
    Records = Web.Contents(apiUrl , options)  
in
    #"Records"

rpzraYTgJ3WAGgi_jga1rrS6h6oB7SHjdg.png

 

 

Click Done and double click on the newly created button in the query editor.

 

eJk-DSPvHl5KCdersoz5Xh0_MkbPMS3j1Q.png

 

Next click on List link:  

URldHP9zL0L34Fl20xodfOW8cimsg1OO0g.png

 

Since the list is in JSON it will show up as single rows, we therefore need to expand it into a table be clicking To Table

Cf_bpiUvKShaQ1QpEk_Z12LhhATnzNA60Q.png

 

In the following window, press OK to accept the default settingsi8eTG0xXbF0YMYF1olzUnBUTxMzxPhF2GQ.png

Now we must expand the each record into columns, you can do that by clicking the expand button: 

Rwnxa4fB2NR7NF2kkcADFNySoJI-QUZOZA.png

 

 

Rename the columns from the slug (ie. field_58) to whatever name makes more sense to you. 

WjhG17FqVHd4lu6bGDsb77veemrAWtDgJQ.png

 

Finally, click on Close & Apply. 

hTB1DsYrvh75XE1rMEHiB4vfo9kgq5LINA.png

 

You'll now be able to use your data in your Tadabase app to create dynamic and powerful reports in Power Bi

YjEE0sHp6bAjAEwSNeICNFMYRwcd7UWg7A.png