Publish/Read csv files residing at AWS fileshare.

[seemeseeu]

We have a senario where we would like to read continusly changing csv files placed in aws fileshare using power BI? we have enterprise on perm gateway setup already. 

[v-juanli-msft]

Hi @seemeseeu 

In Power BI Desktop, you can use Amazon Redshift connector to connect to the instance. 

For more information, please review this article.

After you import data from  Amazon AWS to Power BI Desktop,  you can create reports in the desktop, then publish the Power BI Desktop file(PBIX file) to Power BI service.

In Power BI Service, you can set schedule refresh for your dataset,

in order to set how often it refresh your dataset, you would need to configure on-premises gateway and add Amazon AWS data source under the gateway. For more details, you can review this article.

In addition, there are other references

How to read Amazon S3 data in Power BI 

Best Regards
Maggie

[seemeseeu]

Thanks @v-juanli-msft  i will go over the solution and will get back here with the update... we are still in initial phase of sorting out few other things.