Connect Pivot Table to Power BI
Training Guide
- Click Get Data.
- Click More from the drop-down menu.
- Select Other.
- Select PetroVisor Cloud API.
- Click Connect.
A warning pop-up.
- Click Continue.
Each table created during the exercise will need to be connected to Power BI. Remember the table names created.
- Static Data Set
- Hist and Fcst Gas Rate
- Value Summary
- Enter the API Get request, PivotTables/Static Data Set/Saved
- Enter the Workspace Name, (example here is) Dashboard Demo
The Web API GET request needs to match the name of the table in the workspace. Some errors that occur are extra spaces, naming the table with initials.
- Click OK.
Sign In to PetroVisor.
- Click Sign In.
- Click "Sign in with Microsoft" and continue the SSO to sign into Datagration.
- Connect.
- Notice the API Get Call used to get the Static Table.
Notice it shows the Pivot Table and the API Get call to retrieve the data.
- Click "To Table."
- Click OK. Do not specify a delimiter.
- Click the drop down.
- Click Extract Values.
- Select the Tab as the delimiter from the drop-down menu.
- Click OK.
Notice that the data comes into one (1) Column. The data needs to be split into different columns.
- Click Split Column.
- Selecty By Delimiter.
Ensure that the delimiter selected is Tab.
- Click OK.
The static data is now split into 5 columns as specified in PetroVisor. Notice that the first row is the header row and needs to be specified.
- Click Use First Row as Headers.
- Check the data types that Power BI has selected the correct text types.
- Entity is an integer.
- Well Name is a text.
- Wellbore Profile is a text.
- Formation is a text.
- Surface Latitude is a decimal.
- Surface Longitude is a decimal.
This step is a good check to make sure the table resembles what was created.
- Rename the table "Static Data."
- Select Close & Apply.
Ensure the table was loaded.
- Click Data Field.
Notice that the Static Data is available.
