Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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
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.
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
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |