How to connect Power BI to Clio (or any third party tool that does not have Power BI integration)?

[tvaishnav]

I am trying to connect Power BI to Clio. (https://www.clio.com/)

Per their documentation, they do not have any connector available.  (Does Clio integrate with Power BI? – Clio Help Center)

However, the do have api available. (https://app.clio.com/api/v4/documentation#section/Developer-Support-and-Feedback)

Clio uses OAuth 2.0 authoriaztion. Do you think I Can use this to import data into Power BI?

It would be helpful if someone can breakdown all the steps for me or point me to relevant learning resources.

Thank you so much.

[Anonymous]

Hello @tvaishnav ,

Did you succeed in integrating clio within Power Bi using their api? 

[kamalmsharma]

We have built reports on Clio data by creating a small data warehouse using Azure database. Let me know if you would like to know more about that?

Regards,

Kamal

[V-lianl-msft]

Hi @tvaishnav ,

You could take a look at this third-party connector.

https://virtuas.com/insights/news/power-bi-connector-for-clio/ 

(Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.