Gateway between JD Edwards E1 and Power BI

[bwelch-granite]

Hi,

I have been working to generate reports on PBI with data that I pull down from E1 and then import manually to PBI. I am hoping there is a way to set this up so that the data is refreshed in PBI daily or every few hours.

Currently, when new data is added to E1 I have to manually query the data and then add it to the spreadsheet and re-upload the spreadsheet to PBI, replacing the old spreadsheet. The hope is to cut out the need for me to manually do this by having PBI pull the new data and add it to the created PBI report on its own on a schedule. 

Thank you for any help you might have.