Forum Discussion
Refresh takes a long time
Hello,
I am connecting to excel file in my LAN,
But it takes a long time to get the data,
The excel file contains 11 sheet, 12 named range, and 7 table format (and each table only less than 100 rows)
Some cells in table contain data validation connected to named range list,
I think what make it takes so long is because Power BI try to read all sheet, named range and table,
Anyway my connection is only for some table and excel named range,
How to tell PBI to read only specific area so i can get the data in much shorter time?
This is an example of the query for data source:
Source = Excel.Workbook(File.Contents("\\xx.xx.xx.xx\FolderName\FileName.xlsx"), null, true),
xyz = Source{[Name="SheetName"]}[Data],
9 Replies
Hi simp,
Actually, when connecting to an Excel file from Power BI desktop, if the excel file contains multiple worksheets and multiple table formats, we can select those necessary tables or sheet that we need. Please see below image:
Regards,
Yuliana GuHi v-yulgu-msft,
What i mean is after we click Refresh to the query (Home > Refresh),
In the popup box we can see it is evaluating, waiting, etc
It loops to all of them (Sheets, tables, named ranges) which is unnecessary because i dont use all of them
Hi simp,
So, you only want to update some certain tables when clicking on refresh button, instead of updating all data records imported from Excel, right?
If so, you can disable query refesh for some unnecessary queries so that they won't be refreshed together with others.
Query editor -> right click the unnecessary query -> select properties -> uncheck the 'Include in report refresh' option.
Best regards,
Yuliana Gu
Hi Team,
similar kind of issues I am facing while updating/refreshing tables from ODBC connections, it’s almost taking more than 2hours to update a simple query and there is another system with same configuration which my team mate is using at the moment which will take less than 2min to run the same query.
I have tried uninstalling/installing Power bi Desktop, ODBC connection strings, Data gateways but none of that was helpful.
Any clue on how can I improve the performance.
Below are the configuration details and I am using PostgreSQL.
Hi Team,
similar kind of issues I am facing while updating/refreshing tables from ODBC connections, it’s almost taking more than 2hours to update a simple query and there is another system with same configuration which my team mate is using at the moment which will take less than 2min to run the same query.
I have tried uninstalling/installing Power bi Desktop, ODBC connection strings, Data gateways but none of that was helpful.
Any clue on how can I improve the performance.
Below are the configuration details and I am using PostgreSQL.
Hi Team,
similar kind of issues I am facing while updating/refreshing tables from ODBC connections, it’s almost taking more than 2hours to update a simple query and there is another system with same configuration which my team mate is using at the moment which will take less than 2min to run the same query.
I have tried uninstalling/installing Power bi Desktop, ODBC connection strings, Data gateways but none of that was helpful.
Any clue on how can I improve the performance.
Below are the configuration details and I am using PostgreSQL.
