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

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.

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.

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

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

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