Forum Discussion
D4imi0n
2 years agoHelper I
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 ...
GilbertQ
2 years agoSuper User
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