Forum Discussion

SimonGrams's avatar
SimonGrams
Icon for Helper I rankHelper I
9 years ago

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, ...
Need Help
SimonGrams's avatar
SimonGrams
Icon for Helper I rankHelper I
9 years ago

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.

 

 

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
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.