Forum Discussion

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
9 years ago
Solved

Trying to Add Data Source to Gateway for Excel "Invalid connection credentials"

I've used the "web" data source in PBI Desktop to access an excel spreadsheet that is stored in an Office365 group. This works.   Now, I need to set up the datasource inside the Enterprise Data Gat...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    dramus,

    It doesn’t require gateway in your scenario if your dataset only contains the Excel data source.

    After you publish the Power BI Desktop file to Service, you will find “Connect Directly” in the settings for the dataset, just enter credential for your data source and you will be able to set schedule refresh for the dataset.

     

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

dramus,

It doesn’t require gateway in your scenario if your dataset only contains the Excel data source.

After you publish the Power BI Desktop file to Service, you will find “Connect Directly” in the settings for the dataset, just enter credential for your data source and you will be able to set schedule refresh for the dataset.

 

Regards,
Lydia

PowerDiv's avatar
PowerDiv
New Member
8 years ago

Hi, I have a similar problem where I have connected excel using web data source and getting Invalid credentials error but I do no see the OAuth Option in the dropdown. I can only see 3 options i.e.  Anonymous, Windows and Basic and non of them are able to authenticate me even though I am able to connect properly with Power bI desktop.

  • khamlam's avatar
    khamlam
    Regular Visitor
    8 years ago

    I have the same issue.

Related content