What would be the impact on direct connectivity establishment from jira DB to Powerbi desktop

Maha vishnu v

we are using On-premise jira server having db in Microsoft Sql .,

Jira Db direct connectivity establishment to power bi cause any impact to jira system ?

What would be the potential impact  on direct establishment ? 

Power Bi Jira add-on also we have tested but  we decided for SQL direct connectivity since its not required budgeting . 

We need a SQL query for the below JQl to perform load to Power BI .

project = Test AND issuetype = bug AND "Raised By Team" = "Client "

and also requires some system sprint fields and custom fields to perform data extract  . 

& 

It would be helpful to provide Jira DB ER schema 

 

Thanks in advance 

 

Danyal Iqbal

You can find the schema of your jira version in the online docs.

As a matter of principle, I would stay away from the db. Depending on how often you query the db, and how poorly you write the sql statement you can expect moderate to severe performance issues in jira.

The powerBI plugin would be the recommended course of action here. IMO the value generated by power BI far exceeds the price you have to pay.