How do I transfer data to Power BI?

Hello to all! My task is to gather data from 2 projects and present them in a visually appealing comparative report. The company has Power BI, but I'm struggling to figure out how to extract the data I need and transfer it for visualization. Who uses what for such an operation? please advise with experience

Juliana Buyakova 7.8.2023 20:11

Hello to all! My task is to gather data from 2 projects and present them in a visually appealing comparative report. The company has Power BI, but I'm struggling to figure out how to extract the data I need and transfer it for visualization. Who uses what for such an operation? please advise with experience

You need a connector to link your database with Power BI. These are special plugins that integrate into your project manager and allow you to do exactly what you need - gather and prepare data, transfer it to Power BI, and build your reports there. There are several such plugins available, depending on your project manager. If you're using Jira, I recommend this plugin - [url=https://marketplace.atlassian.com/apps/1224059/microsoft-power-bi-connector-for-jira?hosting=datacenter&tab=overview. The plugin works steadily, does its job, I have never appealed to support. They also offer a free trial period, I believe.

Juliana Buyakova 7.8.2023 20:11

Hello to all! My task is to gather data from 2 projects and present them in a visually appealing comparative report. The company has Power BI, but I'm struggling to figure out how to extract the data I need and transfer it for visualization. Who uses what for such an operation? please advise with experience

this plugin - <a href="https://marketplace.atlassian.com/apps/1222801/microsoft-power-bi-tableau-connector-for-jira?hosting=cloud&tab=overview">https://marketplace.atlassian.com/apps/1222801/microsoft-power-bi-tableau-connector-for-jira?hosting=cloud&tab=overview</a>; is also perfect for this task

We develop products for connecting project management systems and modern analytics tools.
Our connectors are designed for all popular platforms:
- Jira
- Trello
- mondaycom
Through the connectors, you can easily select the data needed for analysis and quickly export them to BI tools, including the Power BI you are interested in
more - <a href="www.doit-bi.com">www.doit-bi.com</a>;