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 Power BI it fails. I have other reports in the same OneDrive, connecting to the same gateway and on-premise database, they all refresh consistently without failure. The error message that I am receiving doesn't provide any details either. Is there somewhere where I can get more details of the root issue?

 

Thanks

9 Replies

  • 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?