Forum Discussion
multiple data sources on multiple PCs or computers
Hi kooroshpashaei Personal Gateway is not what you need here. You'll need the On Premise Data Gateway.
Pretty close, looks like your folder path is not quite correct. Normally when you have a file on your local PC, you would use "C:\Folder\File.xlsx"
You could also use this if the file is sitting on the same machine as the On-Premise Gateway
Typically if you put in on a server and get to it via sharing, it would look like
"\\Server\Folder\File.xlsx"
I've noticed yours looks like
"\\Server\C:\Folder\File.xls" which definately wont work.
Looking at your file location, its under a number of sub-folders. When sharing a folder, often not all of the above folders are included but thats something for you to check in the file sharing menu in Windows.
Thank you very much Ross. Connection Successful.
Hello again Ross, I could configue the on-premises gateway on my PC as you see in the following image. But in datasets tab I could not get ride of personal gateway as you see in the image. How I can say to Power BI service that I am using on-premise not personal and then set data source credential?
Thanks in advance.
Personal is the default regardless of whether you have any gateways installed. If you don't see the On-Premise option under any given dataset, check that each data source in the dataset is included in your gateway. Remembering that gateways need to handle every data source, not just a portion.
Ross, How check that each data source in the dataset is included in my gateway? I do not see in on-premises gateway option for do that !
Open up your project in Power BI desktop. Select "Edit Queries" from the ribbon (under 'Home' tab). In the new window that appears, click on 'Data Source Settings' in the ribbon. Here will be a consise list of all of your data sources. You can click on each one and select "Change Source" which will provide some more details.
To compare to your Gateway, look under "Manage Gateways". You can see a list of data sources that you have configured.
Personal is the default regardless of whether you have any gateways installed. If you don't see the On-Premise option under any given dataset, check that each data source in the dataset is included in your gateway. Remembering that gateways need to handle every data source, not just a portion.
