Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Refresh from Excel file in One Drive For Business

Please help!
My PowerBI Desktop combines SQL query from on-premises SQL Server and definitions taken from Excel file stored in One Drive for Business. Works perfect!
I've installed the on-premises gateway on the SQL Server machine.
When I publish my Desktop model to the service - I have this error in dataset:
 
"Something went wrong
 Your data gateway (Power BI – personal) is offline or couldn't be reached.
Please try again later or contact support. If you contact support, please provide these details."
 
 
When I publish report that only has the SQL queries without OneDriveforBusiness - everything works, I am able to schedule the refresh.
Only when I add the "= Excel.Workbook(Web.Contents(..." query for One Drive for Business - then it shows me the error and I am not able to refresh.
 
Please help - what am I missing?
Thank you
Michael
Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    There is a current limitation within Power BI whereby if you use a Data Gateway for 1 source in a project, you need to use it for all of your sources in that project.

    Solution:  Add your one drive file or folder into your On-Premise data gateway data source list

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks Anonymous for your reply.

      I've tried to add the data source to my on-prem gateway but I cannot see any option to set OAuth 2 credentials.

      I've checked "File", "Web", "Sharepoint" - no OAuth2 option...

      Please help...

      Thanks!

      Michael

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Authentication method of Windows is what i've been using.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     

    Please help
    My PowerBI Desktop combines SQL query from on-premises SQL Server and definitions taken from Excel file stored in One Drive for Business. Works perfect!
    I've installed the on-premises gateway on the SQL Server machine.
    When I publish my Desktop model to the service - I have this error in dataset:
     
    "Something went wrong
     Your data gateway (Power BI – personal) is offline or couldn't be reached.
    Please try again later or contact support. If you contact support, please provide these details."
     
     
    When I publish report that only has the SQL queries without OneDriveforBusiness - everything works, I am able to schedule the refresh.
    Only when I add the "= Excel.Workbook(Web.Contents(..." query for One Drive for Business - then it shows me the error and I am not able to refresh.
     
    Please help - what am I missing?
    Thank you
    Michael