Issue with data sources / gateway

[globe11123]

Backstory - I've hosted our database in AWS, the gateway is located on the same virtual machine, I created a mapped network drive so that on my locally stored powerbi file I could change the data source to the IP of the mapped network drive - the scheduled refresh wont run anymore, which I'm guessing because it doesn't like the fact its an external IP and not a domain controller name?

My question is with my setup of using an offsite server for the data gateway, how do I go about configuring it correctly? This server isn't a domain controller so I won't be joining to it. What are the solutions? 

Also should I be using personal gateway or normal? I can't seem to find any datasources on the normal one.

[v-jayw-msft]

Hi @globe11123 ,

I don't quite understand the situation. 

Make sure the gateway does not install on domain controller.

Connect the data source on Power BI Desktop, publish to Power BI Service, add data source to Gateway and map the dataset.

Which part get the issue and is there any error message?

Best Regards,

Jay

[globe11123]

I haven't got it on any domain controller, ill explain it abit better.

• So I've moved the gateway and datebase to an AWS instance. (Was originally on a server on our premises, and my PC was on the network)
• On my local machine I have a pbix file, which now the datasources are broken.
• I updated all the datasources to \\*IP Address*\*Folder that contains files here*.
  • When I run the refresh this works perfectly from my machine as it can see the data.
• When I publish the file to my workspace, the settings on the dataset doesn't like the path I included above.
  • This is probably because its expecting the path to a local path for the location the gateway is on but I'm guessing it doesn't like an IP address?
• When I try to add it to the gateway, even putting the windows credentials it won't do it either.

path error

If the source is changed to C:\ rather than the IP it works, but then that means when I'm configuring the pbix file from my desktop it won't work.

[globe11123]

As a work around for now I've used a parameter method, which once the local file has been published to the server, I can change the parameter in the service and it reads the paths.

[globe11123]

I've hosted PowerBI Desktop on the instance and it all works now as I changed the data sources to example :- File{"path":"c:\\program files\\filemaker\\filemaker server\\data\\documents\\invoice.xlsx"} which looks the folder on the server which contains the files rather than a mapped network drive on my local machine.

This isn't ideal though as PowerBI desktop uses quite abit of resource to run. Surely there's someone who knows a method.

All I want to do is to be able to have my pbix file hosted on my desktop, edit it on my desktop but to be able to access the files that are hosted on an external server and for the gateway to be able to recognise the path!