Forum Discussion
Questions about automation process
Anonymous,
You can follow the guide in this article to set up gateway. Please note that you shouldn't install a gateway on a computer, such a laptop, that may be turned off, asleep, or not connected to the Internet because the gateway can't run under any of those circumstances.
In addition, you can add the folder within gateway following the instructions in this blog:https://blog.crossjoin.co.uk/2017/07/14/configuring-power-bi-gateway-data-sources-for-files-and-folders/.
Regards,
Lydia
Anonymous,
Is it possible to put all the txt files into a folder? If you can put all the new files in a folder, then you can use Folder connector in Power BI Desktop, expand all the data in a single query, create report in Power BI Desktop and publish the report to Power BI Service.
In Power BI Service, you can add the folder data source within gateway and set schedule refresh for the dataset. This way, once new file is added to the folder, new data will automatically get updated to Power BI Service report based on refresh schedule.
Regards,
Lydia
Hi,
How can I setup the gateway?
Is there any guide about the topic?
Is it important for the gateway to be an on-premise,always active machine?
Anonymous,
You can follow the guide in this article to set up gateway. Please note that you shouldn't install a gateway on a computer, such a laptop, that may be turned off, asleep, or not connected to the Internet because the gateway can't run under any of those circumstances.
In addition, you can add the folder within gateway following the instructions in this blog:https://blog.crossjoin.co.uk/2017/07/14/configuring-power-bi-gateway-data-sources-for-files-and-folders/.
Regards,
Lydia