Forum Discussion

jpperez's avatar
jpperez
Frequent Visitor
6 years ago
Solved

Adding excel as an Entity in Dataflows, failing authentication

I'm trying to create a new entity from an excel file, every time, the issue seems to be authentication.    When I try it on the desktop, it works fine, but using dataflows the sign-in pop up never ...
Dataflow
  • jpperez's avatar
    jpperez
    6 years ago

    I realized I never posted my question.

    I found a "Solution", I had to:

     

    1 use the Web API connector

    2 Copy the file location that is provided within excel desktop.

     

    3 Delete the excess text after the file format when pasting the link

     

    Ex:    https://....sharepoint.com/sites/ModelWarehouse/Shared%20Documents/Reference%20Data/Postal%20Codes.xlsx?web=1)

     

    4 not use an on premises gateway and sign in with my microsoft account, it should look like below:

     

    after using this configuration it worked.

jpperez's avatar
jpperez
Frequent Visitor
6 years ago

I realized I never posted my question.

I found a "Solution", I had to:

 

1 use the Web API connector

2 Copy the file location that is provided within excel desktop.

 

3 Delete the excess text after the file format when pasting the link

 

Ex:    https://....sharepoint.com/sites/ModelWarehouse/Shared%20Documents/Reference%20Data/Postal%20Codes.xlsx?web=1)

 

4 not use an on premises gateway and sign in with my microsoft account, it should look like below:

 

after using this configuration it worked.