Skip to content
Home » Power BI » Page 2

Power BI

Power BI Information, How-To’s, Tips, Tools, and Guides

POWER BI INSTALL & PREVIEW FEATURES

  • Power BI

There are several ways to install Power BI, however the recommended Power BI Install is by going through the Microsoft Store. The reason behind it is, if you install it through the Store, it will auto update monthly. Yes Power BI updates the platform that often, and you will have the latest and greatest version.

Once it is installed, and after the monthly updates you will need to enable the Preview Features. To do this, perform the following:
Click File
Select Options and settings
Click Options
Select Preview features
Place a check mark next to All of them
Restart Power BI Desktop

You have now installed the platform and enabled the extra features.

Thanks for reading

CONNECT POWER BI TO COINMARKETCAP

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

ADDING A DIGIT TO A COLUMN IN POWER BI

  • Power BI

I have an excel file with all of my original data, that i need to modify, once it is in Power BI. To do so, I have worked with a friend to create a simple, but effective code to to this automatically. The zip code is automatically formatted in excel, and changed from 02860 over to 2860. I did not notice it until well after it was within Power BI. So this guide is what I ran through in adding a to a column in Power BI.

Open Power BI
Open the pbix file
Click Home
Select Transform Data
Find the Zip column and highlight it. In My case the column has 2860
Click Add Column
Select Custom Column
Type in the following in the Custom Column Formula dialog box
= Text.PadStart([Zip],5,”0″)
Click Ok

That’s it! I now have a zip code column with the proper formatting of 02860 instead of 2860

POWER BI SHAPE MAP

  • Power BI

When you install Power BI, it does not have certain features enabled. One feature that I need to use, is the Power Bi Shape Map. This quick how-to guide is the way to enable that feature.

Open Power BI
Click File
Click Options and Settings
Click Options
Click Preview Features
Place a check mark next to Shape Map Visual
Click Ok
Now restart Power BI for the changes to take effect

And there you have it, a quick way to enable the Power BI Shape Map