Forum Discussion

D4imi0n's avatar
D4imi0n
Helper I
2 years ago

Error when setting up a data source connection to Excel: Unexpected behavior

Hello everyone,   I hope you have an idea for my current problem. I have published a dataset via Power BI Desktop. The data comes via direct query from an OnPremise SQL Server. A data gateway is ...
Need Help
GilbertQ's avatar
GilbertQ
Super User
2 years ago

Hi D4imi0n 

 

It certainly sounds like an issue related to the Gateway setup, because it is working in other tenants.


Can you confirm that when you are logged into the Gateway that it can access the network path?

Also you might need to log into the Gateway server with the same credentials that you are using to create the data source to see if this account has got access to the network share?

D4imi0n's avatar
D4imi0n
Helper I
2 years ago

Hi GilbertQ,

thanks for your feedback and sorry for the late response.

We have checked the following things:

1. access of the AD account (Power BI Admin) to the gateway server (success)
2. access of the AD account (Power BI Admin) to the network drive and the file (success)

But what I can check again is the exact account of the Gateway service account.
Does it have to have access to the network drive?


    • D4imi0n's avatar
      D4imi0n
      Helper I
      2 years ago

      Hi GilbertQ,

      thank you for your input . I will try to clarify this today.
      I'll get back to you as soon as possible.