Power Query refresh in XL file

Question

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.&nbsp;This worked fine until some days ago&nbsp;using&nbsp;refresh with the "Power BI personal gateway".&nbsp;Then the refresh stopped working. I tried all different possibilities by rebuilding files and more.&nbsp;&nbsp;At this moment have been running trials and it seems like when I use the connection through Power Query to the data in the Excel file I am not able to refresh, but if I make the connection with the Power Pivot interface&nbsp;to the data&nbsp;I am able to refresh.&nbsp;&nbsp;I have both data from SQL Server and ODBC data and both are behaving the same way.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Has there been a upgrade that changed the behavior in Power BI or any other reason that can be addressed?

eric_zhang · Answer

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

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

&nbsp;

flaxman64 · Answer

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

Forum Discussion

Power Query refresh in XL file

2 Replies

Related content

Excel Power Query Refresh

Power Bi refresh

Refresh Direct Query not refreshing

Power Query dates

Data transform using power query