BI Book Power BI Connector

Last updated About 1 month ago

Note: Currently our BI Book connector is only available as a custom connector. We are in the process of getting our connector Microsoft certified so that you can use it out of the box in Power BI. If you are interested in using the custom connector already, contact support@bibook.com

How to use the connector

Step 1: Lookup the BI Book connector in "Get Data"

/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBc3NCIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--347ad45cacf9ad426993d7ec66cd520c922cc45b/Lookup%20BI%20Book%20Connector.png

Step 2: Enter the BaseUrl and your company id

/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBc3dCIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--12d2fb8c88c79f9a3d39572e92b2ca5b2761b550/Choose%20account.png

Note: The BaseUrl you should use is https://bibook.com and you can find your Company Id in the management tab in BI Book. This requires administrator role.

Step 3: Authenticate to BI Book using username and password

/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBczBCIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--baa8852f662b61cba728b9861684e376dea09aa9/Authenticate.png

Note: You can find the username and password in the management/apikeys tab in BI Book. This requires administrator role.

Step 4: Read in the Data

Now you have efforless access to all your BI Book files and SQL tables through an easy to use connector!

/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBczhCIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--f197591b85aa54360a0fc1c379354316b0c1d2d1/Read%20in%20the%20Data.png

Remember: We have built data pipelines to over 50+ systems and we are continuously adding support for more systems in BI Book. Checkout out our available connectors here: Connectors (bibook.com) When activating the connectors through BI Book all of your activated systems' data is ready to be used and explored by you in Power BI through these steps described in the article!

Ps. Please help us get the connector certified by upvoting this idea: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=25c48555-5b8f-ee11-a81c-000d3a00bef9

Feel free to contact support@bibook.com in any questions!