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

Pooja_Pandya's avatar
Pooja_Pandya
Icon for Helper I rankHelper I
5 years ago

Hi,

I also have the same issue. I tried to execute your solution but I can't see  "connect directly" as an option under my gateway connection. Please guide.

Related content