On-premises data gateway - Unable to create data source. Invalid connection credentials

[RiddhiK]

I am unable to create a local data source on my on-premises data gateway. Eveen after adding the correct credentials and file path, I get below error message. I am using enterprise mode. 

Any help is much appreciated. Thanks in advance!

[v-luwang-msft]

Hi @RiddhiK ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[RiddhiK]

@v-luwang-msft Thanks for the tip. Unfortunately, I am still unable to create the data source 😞

[v-luwang-msft]

Hi @RiddhiK ，

Have you checked the box “Skip test connection”?

Best Regards

Lucien

[v-luwang-msft]

HI @RiddhiK ,

Refer the below :

create step like the below:

Then click setting,enter username and password and save:

At the beginning, I entered all of them and had the same problem as you, then I used the following method and it worked.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Anonymous]

Your source is a file and you will have to specify the full detail of the file path. This would be the \\servername\folder\file.extension

let me know if that works.

[Anonymous]

Hi @RiddhiK 

Your filepath is the problem.  Whenever you connect to your files you should use the format "\\Server\Test".  The path in your screenshot is "C:\Test"

You will likely need to update your PBIX file and the gateway to make use of a network folder that is accessable by both your Gateway and your Power BI Desktop.

[RiddhiK]

Hi @Anonymous , thanks for your prompt response. Can you please elaborate, what do you mean by "\\Server\Test"?

[Anonymous]

I think you need to spicify your path, I am curious why it is local host? Chang "C:" to server name