This repo will help you set up GCP billing on Datastudio, alongside forecasts and stuff.

Instructions

Copy Data Studio template: https://datastudio.google.com/c/u/0/reporting/0B7GT7ZlyzUmCZHFhNDlKVENHYmc/page/tLtE
Follow instructions on "How to Copy". Alternative you can use make install
TODO(ricc): use Dtastudio APIs to automate the rest.

Original instructions by Mike

1) Navigate to the Billing -> Billing Export section in the cloud console.

Select the BigQuery export, project, and dataset which data will be exported to (See docs [1] for additional help).
Navigate to DataStudio and create [2] a Data Source over the new billing table.

Navigate to DataStudio and create a Data Source using the BigQuery "Custom Query" source. Paste in the contents of the query at https://bit.ly/2KXHk2G. You'll need to change the dataset and table names to match your datasets and tables.

1) Click here [3] to navigate to the Stackdriver Logging pane in the cloud console.

Select BigQuery from the dropdown of resources and click the Create Export button at the top of the screen.
Name the export, select BigQuery as the destination, choose the dataset you would like the logs output to and click create. You'll need to create the dataset first.
Once, audit data is flowing to your dataset (normally a few mins, you may want to run a few test queries to generate some data) , create a view on top of the audit table using the saved query at https://goo.gl/PSFzNN. You'll need to replace the dataset with your own for the query to work over your dataset.
Navigate to DataStudio and create [4] a Data Source over the BigQuery view. Be sure to change the TotalCost field to a currency data type.

1) In the top right-hand of this report, click the copy button