Forum Discussion

jamesholland198's avatar
jamesholland198
Frequent Visitor
6 years ago

Dataflow Excel Gateway Connections Issues

Hi,

 

Really hoping someone can help as this has me stumped and is something that seems to have changed in the last week.

 

I have a number of existing Dataflows, all with a mixture of On Prem and Excel Web files.  These existing Dataflows work fine and were only setup 1 week ago.

 

I'm now trying to set up another new Dataflow, again a mixture of On Prem and Excel Web files.  On Prem setup works fine, can select the Gateway and connect.  When I then want to add an Excel Web connection by copying the M code from the working Dataflow into a blank query on the new Dataflow, I then can't authenticate.

 

I have to select the On Premises Gateway (even though not required as cloud files) otherwise I get a message saying "Changing the on-premises data gateway will apply to all queries in this mashup"

 

Whenever I try to authenticate through the Gateway no matter which method I try, I get login errors as below.  So puzzling as I'm doing nothing differently to last week when I added about 50 entities across 4 Dataflows, all of whihc same sources as I'm trying to add to the new Dataflow.

 

Organizational Account:

 

 

Windows Account:

 

 

 

Would really appeciate any help at all.

 

Thanks,

Dataflow

5 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    Hi. This is confusing. This is quite confusing. The Web.Contents don't need a gateway, you can just enter credentials activating the setting in "Manage Gateways":

    If have this checked you don't need gateway for Web.Contents. 

    On the other hand if you are sure that you can't access web and it's on premise only, then you might consider using File.Content and a Windows path. I don't think you can configure a windows credentials for web.

     

    Regards, I hope that make sense.

    • jamesholland198's avatar
      jamesholland198
      Frequent Visitor
      6 years ago

      Thanks for your reply.  Yeah I maybe wasn;t clear in my first post, it's difficult issue to explain

       

      I know that you don't need to add web sources to the Gateway, it's just that because my Dataflow already contains an On Prem source, the Gateway is applied to this Dataflow.  And so when I try to add web sources to the Dataflow, it still makes me select the Gateway:

       

       

       

       

       

      Then when I sign in to Organizational account, I get the below error:

       

       

       

      It's just so confusing as I was able to do this with dozens of Web sources last week across numerous Dataflows, yet all of a sudden these authentication issues have started.

       

      If I try to Authenticate using Windows login instead, I just get "Invalid credentials" - even though it works fine when creating a dataset using the same sources and queries directly in Desktop.

       

      Any help would be appreciated, thanks

      • ibarrau's avatar
        ibarrau
        Super User
        6 years ago

        Dataflow will suggest the gateway, but you can change the onpremise gateway to "none" and continue without it. If your excel is in sharepoint it should ask for microsoft professional account (organizational account or auth2).

        Have you tried that?