Forum Discussion

Flaxman64's avatar
Flaxman64
New Member
9 years ago

Power Query refresh in XL file

I have been importing Excel files with "Get Data" where the files are stored in One Drive Business. I selected the "Connect, manage and view Excel in Power BI" option.   This worked fine until some...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

Flaxman64

There's a known issuen for excel on Onedrive business. Check Awareness on the support page. 

We have identified an issue preventing data refresh for Excel files in Power BI and Office 365 Excel Services. Within Power BI, the affected excel files use the 'Connect, manage, and view Excel in Power BI' option. Data for affected files will not refresh until a fix is deployed. A workaround is to open the affected file from it's OneDrive for Business or SharePoint Online location in Excel Desktop, refresh, and save it. The updated data will be visible in Power BI within 15 minutes of saving the file. Power BI team is working with the Excel Services team to deploy a fix. Next Update @ 03/20/2017 12:00 PST

 

  • Flaxman64's avatar
    Flaxman64
    New Member
    9 years ago

    Thanks for information I will look forward to the fix. Also learning to look for the "Awareness" for details of problem.

    Thanks for replay