Report refresh issue

[Kish1999]

Hello All,

I have a report which is primarily getting data from JIRA using the AIO Connector and Sharepoint. None of the tables have very huge data. The number of rows are usually ~200000. But our report usually times out in power BI service, even when the refresh succeeds, it takes more than 1.5 hours. We do have some transformations in the power query editor and things like that but i can't understand why it takes so long to refresh. Can someonle please suggest some effective ways to reduce the refresh time.

Thank You!

[ibarrau]

Hi. The Power Bi Service has some limitations regarding dataset refreshes. One of them is 2 hours limit to refresh the dataset, otherwise it returns timeout. Another timeout can be send by the source, if JIRA has limitations for some data it can return a timeout like a database. In my personal experiencia I think taking 200000 rows from JIRA is long and heavy process. The API can only return 1000 or 5000 rows by request depending on the request. So imagine that the process from the connector or power query it's paginating a lot of times to get your amount of rows.

I strongly suggest not connecting any API directly from Power Bi if you want to build a mature analytics structure with many rows.

For example I have a lakehouse that runs databricks process populating tables with JIRA info. Then PowerBi can just read data from a table very fast and easy.

That's my guess. I hope it helps,