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
- Production and Completion Summary
- Value Summary
- Enter the API Get request, PivotTables/Production And Completion Dashboards Visualization - Production/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.
- User Name and Password are required.
- 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.
- Gas (MSCF/d) is a decimal number.
- FGas(MSCF/d) is a decimal number.
This step is a good check to make sure the table resembles what was created.
- Rename the table "Production."
- Select Close & Apply.
Ensure the table was loaded.
- Click Data Field.
Notice that the Production Dashboard is available.
