Forum Discussion

Reza's avatar
Reza
Icon for Helper II rankHelper II
8 years ago

Refresh fails for Excel workbook on OneDrive

Hi everyone,   I have an excel workbook that connected to an Azure database. It is working fine and refresh works.  I then uploaded this to the OneDrive-Business of one of our account with free Po...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Reza,

 

How did you get data from the Excel file on OneDrive for business?

 

 

In my test, if I choose "Connect", there is no need configure data gateway for workbook refresh. And I can manually refresh the workbook successfully. As mentioned in this document, gateway is not required in case that "Power Query* is used to connect to and query data from any listed online data source and load data into the Excel data model".

 

If I choose "Import", then, a new dataset is created rather than a workbook. To enable scheduled refresh, I only need to turn on the "OneDrive refresh" option.

 

Best regards,

Yuliana Gu

  • Reza's avatar
    Reza
    Icon for Helper II rankHelper II
    8 years ago

    Hi v-yulgu-msft,

     

    Thanks for the reply.

    I chose Connect and I deleted and added again in case I have done any mistake.

    So when I go to schedule I see the credentials not set. And as you can see the Gateway is not set.

     

    I then set the credentials to Basic with correct username/password of my Azure database. 

     

     

     Then perform manual refresh. And back to schedule I can see the error

     

     

    If I select Import which creates Dataset then refresh works.

    That's where I am struggling to understand what is the difference!

     

    Thanks