Refresh from Excel file in One Drive For Business

[Anonymous]

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

[Anonymous]

 

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

[Anonymous]

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

[Anonymous]

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]

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]

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