Forum Discussion
Gateway Not configured Correctly. File cannot be added to the dataset
Super UserHey juanpv19 ,
I have difficulties to follow due to the non-english screenshots, and I'm currently on the go and for this reason can not check using my gateway setup.
One question, where is the gateway installed?
I assume you installed the gateway using the enterprise mode, meaning not the personal mode.
When the gateway is installed there is a service account, you have to make sure that the service account use is able to access the csv files. I recommend to use a managed service account.
Even more I recommend, that you put the csv into a Sharepoint online library or store them to a onedrive for business folder, this will make the need for an gateway obsolete and is considered more securea, as a service account does not have to have access to the file system
Regards,
Tom
Hi tom. Thanks.
One question, where is the gateway installed? [JP] It is installed in a windows server
I assume you installed the gateway using the enterprise mode, meaning not the personal mode. [jp] Yes, enterprise
When the gateway is installed there is a service account, you have to make sure that the service account use is able to access the csv files. I recommend to use a managed service account. [Jp]The service account is the email that I register in the gateway? Or is the service account the user that is configured in the "Gateway Service account". I register the gateway with my powerbi account email and the "Gateway service account" with a local admin user of the server. I also checked this user is able to access the files:
On the other hand:
I am developing a number of apps based on many csv files that are changing every day in the server. Many apps will use the same csv file sometimes. In that case is better to put the files in a one drive for business and avoid using the gateway? If that is better then this change everything.
Thanks a lot and happy new year!
Regards
Juan Pablo
- TomMartens
Hey juanpv19 ,
use a Sharepoint online library or a onedrive for business folder. This will make the gateway obsoleted, as both are being considered "cloud based" storage.
Regards,
Tom
