Forum Discussion
Onedrive data refresh failure
Sorry but I thnk it is supported, otherwise this article wouldn't have been published:
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-excel-file-onedrive/
Also, as mentioned earlier, I have other excel workbooks, located in a oneDrive, that we are refreshing on a regular basis using Power BI Enterprise Gateway.
Hi burnie21,
Based on my understanding, the Excel for Power Pivot data model retrieve data from SQL Server database and this Excel file is stored in OneDrive. Then you connect to this Excel file in Power BI Sevrice. Right?
In your scenario, I would like to know how do you connect to OneDrive Excel file? Use "Import Excel data into Power BI", or "Connect, Manage, and View Excel in Power BI" option? And are you connecting to a personal OneDrive, or OneDrive for Business? Please share more information for us, so that we are trying to reproduce the issue.
In addition, you can take a look at those articles about how to troubleshoot refresh issues:
Tools for troubleshooting refresh issues
Troubleshooting refresh scenarios
Best Regards,
Qiuyun Yu