Logo
For example "scheduled tasks"
Search
Info
Content
Category Navigation
  • 📖  Manual

  • 👋Welcome

    Welcome to Tadabase

    What Is No-Code?

    Tadabase Support

    Getting Started With Tadabase

    Platform Overview

    🧰The Data Builder

    Data Tables

    Fields

    Text Fields

    Personal Fields

    Number Fields

    Date Fields

    Option Fields

    File and Image Fields

    Equation Fields (Category)

    Equation Fields

    Connection Fields

    Date Equation Examples

    Records

    Record Logs

    Import Templates

    Export Templates

    Automating Tasks

    Number Equation Examples

    Text Equation Examples

    Multi-Function Equation Examples

    ✏️Page Builder

    Page Builder Overview

    Layouts

    Pages

    Components Overview

    PDF Pages

    📗System Components

    System Components Overview

    Menu

    User Menu

    Breadcrumbs

    PDF Print (Alpha)

    Link Button

    Login

    Signup

    Profile

    HTML

    Image

    Subscriptions (Alpha)

    📘Data Components

    Data Components Overview

    Form Component

    Table Component

    List Component

    Kanban Component

    Calendar Component

    Resource Component

    Map Component

    Timeline Component

    Accordion Component

    Card Component

    Chart Component

    Search Component

    Import Component

    Data Source

    Data Source Filtering

    Links

    Display Rules

    Inline Editing

    Data Component Visual Directory

    Custom Component

    Custom Component Helpers

    Writing Your Own Component Helpers

    🙋Users

    Users

    Roles

    Single Sign On (SSO)

    Adding Stripe Subscriptions

    🔒Security and Reliability

    Tadabase Builder Security

    App Security

    User Security

    🔗Integrations

    Zapier Integration

    Using Webhooks

    Saving files to Dropbox

    Adding PayPal payment buttons to your app

    Exporting records to Google Sheets

    Viewing data in Microsoft BI

    Chat Widgets

    REST API

    Using SendGrid for emails

    Saving files to AWS S3 Bucket (IAM Method)

    Incoming Webhooks

    Embeddable Components

    Saving Files to Custom S3 Bucket (Account Method, Recommended)

    PDF Forms

    Stripe Checkout

    JavaScript Callbacks and Actions

    Twilio Integration

    ⚙App Settings

    General Settings

    Layout & Format Settings

    Custom Domain

    Customizing CSS

    Changing app themes

    Support Settings

    404 Error Page

    💳Account

    Plans

    Managing Your Account

    Sharing your app builder

    Managing your Apps

    🧩Pipes

    Introduction to Pipes

    Adding Pipes

    Using Pipes

    PDF Gen V2

Categories
📖 Manual
🔗 Integrations
Viewing data in Micros...

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. 

Please note: This guide is an introduction on how to get your data into Power BI. Tadabase's API will return a paginated response, as seen in our developer documentation and the query below. For information on how to build data models, manage connected records, and paginating through a REST API response - Tadabase is unable to provide support on these topics.

 

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 and developer documentation.

 

let
     apiUrl = "https://api.tadabase.io/api/v1/data-tables/<REPLACE-WITH-YOUR-TABLE-ID>/records?limit=100&page=1",
     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"

 

The script above will only load the first 100 records. To paginate through all the records  you can try the script below instead: 

let 
    apiUrl = "https://api.tadabase.io/api/v1/data-tables/<REPLACE-WITH-YOUR-TABLE-ID>/records",
    perPage = 100,
    GetJson = (Url) =>
        let 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>"
			          ]
		          ],
            RawData = Web.Contents(Url, Options),
            Json    = Json.Document(RawData)
        in  Json,

     GetPage = (Index) =>
        let Page  = "page=" & Text.From(Index),
            Limit   = "limit=" & Text.From(perPage),
            Url   = apiUrl & "?" & Page & "&" & Limit,
            Json  = GetJson(Url),
            Value = Json
        in  Value,

     getRecords = (page as number, AccumData as list) =>
            let
                Data = Function.InvokeAfter(()=>GetPage(page), #duration(0,0,0,2)),         
                Result =      
                    if page >= Data[total_pages] 
                    then Table.FromRecords(List.Combine({AccumData, Data[items]}))
                    else @getRecords(page + 1, List.Combine({AccumData, Data[items]})) 
            in
                Result,
 
    Records  = getRecords(1, {})
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 settings

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

How did we do ?

Previous Article
Exporting records to Google Sheets
Next Article
Chat Widgets
Back to top
Developer portal Tadabase Community
API
100% Operational
Apps
100% Operational
Builder
100% Operational
Overall Status
100% Operational