Data refresh from Desktop takes huge amount of time

[Enigma]

I have a SharePoint list with ~6k rows. When I refresh the query from the QueryEditor, it takes hardly 3-4 minutes to complete the refresh. However, when I refresh from Desktop, it takes more than 2 hours. What could be the cause of this huge time difference?

Also, I am not sure about the size it shows during the load process. Is there any way to verify the shown size?

[v-jianboli-msft]

Hi @Enigma ,

 You can optimize your solution at different architectural layers. Layers include:

• The data source(s)
• The data model
• Visualizations, including dashboards, Power BI reports, and Power BI paginated reports
• The environment, including capacities, data gateways, and the network

Besides, here is a thread similar to your problem. Hope it would help you!

Solved: How to exclude deleted SharePoint files - Microsoft Power BI Community

For more details, please refer to:

Understanding and optimizing dataflows refresh - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Enigma]

My SharePoint list earlier had about ~28k rows, of which I deleted the old data and brought it down to ~6k to speed up the refresh. However, when the refresh happened all of the deleted 28k rows are also seen in the report. Maybe that's why I saw no difference in the refresh time. It took the same 2 hours time as it used to before I deleted the rows.

The deleted rows are still in the SharePoint site's Recycle Bin. Could it be possible the rows from the Recycle Bin are also being pulled in the dataset?

I am unable to get any breakthrough in this issue, so will appreciate if anyone can help out.