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...
dimazaid's avatar
dimazaid
Microsoft Employee
10 years ago

Hi burnie21,

You do not need an Enterprise Gateway to connect to your OneDrive file, you should be able to connect to it as any cloud resource. 
What other data sources you have in the same PBIX?

burnie21's avatar
burnie21
Microsoft Employee
10 years ago

Hi dimazaid

I am using the Enterprise Gateway to refresh the connections that are contained within the excel file. The data sources are used in a powerpivot model that connects to an on premise SQL database. The data refreshes just fine when I run the refresh in excel but I get an error when refreshing in power bi.

 

Thanks

 

 

  • dimazaid's avatar
    dimazaid
    Microsoft Employee
    10 years ago

    I see. This scenario is still not supported. If possible, can't you connect the SQL datasource to your PBI directly?

      • 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