Needless to say, I have been mining a while, and have some crypto that I want to keep track of. How do you do this, you ask….Well I just have to Connect Power Bi to CoinMarketCap, list my coins, and off I go. This quick and easy guide is how I will connect Power BI to CoinMarketCap.
Open Power BI
Click File
Select New
Click Get Data
Select From Web
Click Advanced
For URL Parts you will want to enter in the following:
https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest
In the HTTP request header parameters(optional) first box, type in
X-CMC_PRO_API_KEY
In the Second Box you will want to enter in your CoinMarketCap API Key
To get the API Key, use the web browser on your computer (Not inside Power BI) and go to
https://pro.coinmarketcap.com/account
Sign up for an account if you don’t already have one
If you do have an account, login
Hover over the API Key box and click Copy
Back to Power BI
Now in the Second Box you will want to enter in your CoinMarketCap API Key
Click Ok
Power BI will now connect to CoinMarketCap
In Power Query
Click data
Select list
Select the To Table button
Use defaults and Click OK
In the Column header, click the button on the top right
Click (Select All Columns)
Select Ok
Click the the Column1.tags header, click the button on the top right
Select Extract Values
Hit the Drop Down
Select Comma
Click Ok
Click the the Column1.quote header, click the button on the top right
Place a checkmark next to USD
Click Ok
Click the the Click the the Column1.quote header, click the button on the top right
Place a checkmark next to USD
Click the the Click the the Column1.quote.USD header, click the button on the top
Click (Select All Columns)
Select Ok
Click the Save Icon at the top left
Click Close and Apply
Documentation on the various CoinMarketCap commands can be found at https://coinmarketcap.com/api/documentation/v1/#section/Endpoint-Overview
