How to connect my organizational productivity application

[48093]

Hi team,

In my organization we have our own application for productivity tracking developed by internal software team. How can I connect that application throguh power bi? Which one should I use from Get Data tab?

Your response is really helpful. Thanks in advance. 

[v-shex-msft]

Hi @48093,

Any available api or other connection drivers available on your applications? If not, did it support to export local files for analysis?
For this first scenario, you can use web connection or correspond data connector drive to get data to power bi desktop and design report to publish to power bi service.

Pull data from a REST API Authentication 
For the second situation, you can use excel, JSON, XML.. or other file connectors to get data from exported files for analysis.

Data sources in Power BI Desktop 
Regards,

Xiaoxin Sheng

[Greg_Deckler · Accepted solution]

You will need to discuss with your technical team how that application was built. You can almost certainly connect to the database. It was likely built on SQL or Postgres or MySQL all of which Power BI supports. They may have built a web API interface for it which in that case you could potentially use OData, XML, JSON, etc. Power BI also supports all of those as well.

[amitchandak]

@48093 

Can you connect directly to the database. Do you have business logic to get the thing working?

If you have Database  access you can work on direct query or import mode. The direct query depends on the database.

https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages

https://docs.microsoft.com/en-us/power-bi/guidance/

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-BI-power-hour/td-p/712497