Forum Discussion
Trouble regarding manual Excel data refresh
Since nearly a week I am experiencing big problems regarding the manual refresh of data from a locally stored Excel file in PowerBI Desktop. The Excel (.xlsm) contains 1 tab with 30 web queries, ...
Hello Eric_Zhang
The Excel web queries are Webtrends web services URLs.
No, it's not possible to redo "get data". After choosing the Excel, PowerBI is not able to connect to the Excel file.
SimonGrams wrote:
Hello Eric_Zhang
The Excel web queries are Webtrends web services URLs.
No, it's not possible to redo "get data". After choosing the Excel, PowerBI is not able to connect to the Excel file.
I think that is why the refreshing is spinning. Could you cut the Excel and paste it in another folder? I doubt there migbt be some other process that is locking the excel that stops Power BI accessing the Excel.