Forum Discussion

sukajalan2's avatar
sukajalan2
Frequent Visitor
7 years ago

Long report refresh in PBI Service

I have a report that takes about 10 minutes to refresh in PBI Desktop. The raw data are in .xlsx file type and located in SharePoint. In PBI Service (Premium), the refresh (scheduled, once a week) ta...
Need Help
sukajalan2's avatar
sukajalan2
Frequent Visitor
7 years ago

I am using several files from several SharePoint folders. The files are coming daily/weekly with timestamp in the filename. In each query, I sort the filename and select the latest file (sometimes the previous file like from last week). I do not think I can use the web connector.

 

Could you please clarify what advanced operations mean? There are some calculations in my queries but why is it a big difference running the report in PBI Desktop vs. Service?

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI sukajalan2 ,

Advanced operations means: merge, combine, reference other query, invoke custom function on query table side. The may cause the looping calculation with query tables.(increase memory usage and reduce refresh performance)

In addition, you can also take a look at following link about power bi performance practices:

Power BI performance best practices

Regards,

Xiaoxin Sheng