Slow power BI

[Pranoti98]

I have connected power bi t KOBOtoolbox, its getting data fom there, Data size is 21M and updates everyday. AT the start it used to take 2 hours..3 hours even that time data was pretty less. But not its taking more than 5 hours whihc is strange. 
I have worked on power Bi before, never faced this kind of the issue. I s it because i am using trail version of power bi?

My laptop also have good RAM.
I am not getting exactly whats the issue caue 21M is not a Big data. 
It will be very helpful if anyone could help me out with this.
Thanks

[v-dineshya · Accepted solution]

Hi @Pranoti98 ,

Thank you for reaching out to the Microsoft Community Forum.

You are connecting to  power bi t KOBOtoolbox,  the data size is 21M. and updates everyday. It is taking more than 5 hours time to get the data.

Please try below things to fix the issue.

1. KOBO is an API-based source, not a direct database. API calls can be slow, when the API throttles requests, Data is fetched in multiple chunks and Network latency is high.

2. If you have many steps like merges, calculated columns, applied filters, Power BI re-applies them every refresh. Check if you are using Table.Buffer or any unnecessary joins.

3. If you are loading everything into a single table without aggregations, refresh time increases. Disable Auto Date/Time for large datasets.

4. If you refresh the entire dataset daily, it will take longer time. Use Incremental Refresh to update only new records.

5. The trial version does not limit performance. It only limits features like sharing and Pro capabilities. So this is not the reason.

6. KOBO is cloud-based, slow internet or API throttling can cause delays.

7. Check Query Diagnostics in Power BI under Power Query --> Tools --> Query Diagnostics.

8. Push heavy transformations to KOBO or use SQL-like queries if possible.

9. Remove unnecessary columns.

10. Use Import Mode instead of DirectQuery.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @Pranoti98 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @Pranoti98 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh