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?