Bring data from Pinnacle sports and Puckalytics into a database that can be updated dynamically and linked to Power BI dashboarding.

I want a database created that pulls price data from (I assume this would be through the XML Feed): [login to view URL] I want the prices to be stored with a timestamp and the connection able to be refreshed so that updates in prices are stored in addition to the previous data with a new timestamp. I also want a separate table that brings in the data fromthe table at: [login to view URL] I want this to be dynamic so the data can be constantly refreshed. I'd then like these tables to be fed into Microsoft Power BI so I can then build dashboards off.