Skip to main content
To homepage To homepage
Solved

Connect to excel files with Excel online - Authentication failed. Empty OAuth file

  • November 19, 2024
  • 5 replies
  • 71 views
A
Participant

Hi,

I am trying to connect to excel files stored in a Microsoft SharePoint. I have followed the guide Connect to Excel files with Excel Online. I have created a Custom OAuth App for Azure Service Principal Authentication and assigned the role Owner to the created OAuth app. I added the Sharepoint URL under MISC and added Azure tenant, OatuhClientID and OAuthClientSecret.  However, when I press the “Authorize OAuth” I get: 

 

Authentication failed. Empty OAuth file.

Details:

Authentication failed. Empty OAuth file.
Module: timeXtender
System.Exception
   at TimeXtender.DataManager.ODXCDataSourceHelper.Authorization(ConnectingThread thread, OperationalDataExchange operationalDataExchange, CDataSourceModel cDataSourceModel)
   at TimeXtender.DataManager.EditDataSourceCommand.<>c__DisplayClass10_0.<Dialog_OnOAuthRequested>b__0()

 

I'm not sure what I might be overlooking. I've set "Initiate OAuth" to GETANDREFRESH and have tried both CLIENT and CODE for the OAuth grant type. Any tips or advice would be greatly appreciated. I am on version 6766.1 

Best answer by Christian Hauggaard

Hi ​@annfoss 

Can you please try to use the TimeXtender Excel data source? Please see the following guide

 

View original
Did this topic help you find an answer to your question?

5 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi ​@annfoss 

Can you please try to use the TimeXtender Excel data source? Please see the following guide

 

A
Participant
  • annfoss
  • Author
  • Participant
  • 14 replies
  • November 20, 2024

Thank you, ​@Christian Hauggaard. I will try this instead. Is this provider more suitable for the newest version of TimeXtender?

 

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

​@annfoss Yes we recommend using the TimeXtender Excel data source rather than the Cdata Excel data source, and TimeXtender data sources over Cdata data sources in general

A
1 person likes this
  • A
    annfoss
Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi ​@annfoss did you manage to resolve the error using the TimeXtender Excel data source?

A
1 person likes this
  • A
    annfoss
A
Participant
  • annfoss
  • Author
  • Participant
  • 14 replies
  • November 25, 2024

Thank you, ​@Christian Hauggaard. Yes I managed to resolve the error using the TimeXtender Excel data source instead!

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings