Forum Discussion
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 ...
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?
Hi D4imi0n
You are 100% right, you would need to change the account used by the On-Premise gateway to use one of your AD accounts that would have access to the file share.
This will then allow the gateway to connect to the file share using the service account.
Change the on-premises data gateway service account | Microsoft Learn