Refresh time is too high in Bi Desktop

[Karthik12]

Hello Team,

I have get date from MySQL from remote server and build data visuals in Desktop.

Whenever I Tried to refresh data it is takes about 10 mins. 

May I get your help to resolve?

[Karthik12]

@PijushRoy Yes, data from MySQL and 4 different tables of a single database.

It was working fine till few months before but now days it was not working. Same I have published in service where there is no such issues.

[Idrissshatila · Accepted solution]

Hello @Karthik12 ,

The issue has been sloved in Version 2.130.930.0.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

[PijushRoy]

Hi @Karthik12 

As per the screenshot you attached, all the files data coming from One SQL table, right?
The data loading process depends on Power Query steps, marge data, combine data etc
Please try to optimize the Power Query steps 

Let me know if that works for you

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Idrissshatila]

Hello @Karthik12 ,

I don't know if it's related, but there's an issue in refresh tables in Power BI,

you can check the thread anc comment your problem there 

https://community.fabric.microsoft.com/t5/Issues/Single-table-refresh-not-working-in-June-2024-versi...