Forum Discussion

ErikSierra7's avatar
ErikSierra7
Frequent Visitor
1 year ago
Solved

Power Bi service gateway connection - File connector

I have an excel file that sits on a network drive that I used to source in my Power Bi report. However, when I try to create a connection on our on-prem gateway using the 'File' connector type and se...
Need Help
  • tayloramy's avatar
    tayloramy
    1 year ago

    Hi ErikSierra7, 

     

    When creating the connection are you adding the domain before the user? 

     

    DOMAIN\USER 

    For example, if I was in the domain "company", I would add company\taylor as my username. 

     

    If this helped, consider giving some kudos. If I answered your question or helped solve your problem, mark this post as the solution to help futute forum users find it. 

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi ErikSierra7 

Thank you for reaching out to the Forum community.

Please note that the File connector in Power BI Service does not support the use of alternate credentials. It will always utilize the Windows account under which the On-premises Data Gateway service is running to access the network share. To resolve this, you should configure the gateway service to run under a service account that has the necessary permissions for the file location, and then restart the service. If you require different credentials for separate shares, you will need to set up additional gateway instances accordingly.

Regards,
Sreeteja.

ErikSierra7's avatar
ErikSierra7
Frequent Visitor
11 months ago

Hi Anonymous Thank you for your response. tayloramy provided the correct solution. When creating a new connection with the File connector, it prompts user to input Windows credentials. I was able to use the service account credentials (with domain\) without needing additional gateway config. Thank you!