Forum Discussion

burnie21's avatar
burnie21
Microsoft Employee
10 years ago

Onedrive data refresh failure

Hi,   I am getting a data refresh error on a file hosted in OneDrive, using data managment gateway (Enterprise). The file refreshes fine using excel in the desktop, but when I try to refresh in Pow...
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

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

  • burnie21's avatar
    burnie21
    Microsoft Employee
    10 years ago

    Hi Qiuyun Yu,

     

    All of your assumptions in your first paragraph are correct. Regarding your question of how we are connecting the OneDrive file, we chose the option of "Connect, Manage, and View Excel in Power BI", and this file is stored in a OneDrive for business folder.

     

    Thanks,

     

    Brian

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      10 years ago

      Hi burnie21,

       

      Based on my test, refresh data from OneDrive file doens't need gateway. When the SQL Server table is updating with new records, we need to refresh the Excel via Data -> Refresh All button, then save the change. Then when we click Refresh Now in Power BI Service, the PowerPivot table data will update correspondingly. Please follow the steps like us to check if the issue persists.

       

       

      Best Regards,
      Qiuyun Yu

      • burnie21's avatar
        burnie21
        Microsoft Employee
        10 years ago

        Sorry but that doesn't make sense. My understanding is a gateway is necessary in order to process any queries to on-premise sql databases. What you are describing suggests that a gateway isn't necessary for running queries to SQL on premise.