Yes, I have taken historic data from coinmarketcap with power bi. Need a separate query for each coin on historic data, but then all the queries can be appended. their api does not support historic data so I have to connect to the webpage and modify the date range in M