Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

GCP Billing & FinOps


I'm actually looking up to how integrate GCP billing data into PowerBI. So, I connect the billing data from project to a BigQuery, I connect my PowerBI to BigQuery with the billing data.

When I have a look into the data in PBI, it just impossible to extract data from columns. Per example, in "credits" I have





I have no idea the matching of these values with the kind of data. But, when I go through Data Studio from Google, the kind of data appear, I have 5 data regarding credits, it could match the 5 fives I got in PBI.




I think, data from Google are missing...

Is there anyone here who work on this topic and wants to share his experience with me ?


Frequent Visitor

Hi, I have the same problem.

About change billing project id don´t resolved for me.  


I will open a ticket about this case for me.

In my case I had to do a split based on the characters for each column analyzing the bigquery schema, but that took a lot of steps and the data update flow hits the limit of the pro version (dataflow refresh limit 2 hours) and I end up having an error and not updating the data. I had to remove unused columns, among others, but it worries me because I have an error every 5 days, etc.

I say this because I also load much larger Autonomous DW (OCI) data and I don't suffer from refresh.

I realized that there is no way to transform this column into json and try to convert it into a table or somehow load the data correctly.

It can be noticed that with split I explored the divisor character because for each column you can have two or more values, being name and key value..



look after this job (long time kkk)



Frequent Visitor



Thanks for your answer. I think we didn't understood each other. It is not a connection or access problem.


I have access to my project who is the repository for billing. But, when i go through PBI, the value for column SERVICE => {"v":{"f":[{"v":"6F81-5844-456A"},{"v":"Compute Engine"}]}}" is ununderstandable !!!


Is there a table for that ? When I go through Google Data Studio, seems the value is decomposed as shown in my first example.


To resume, I can connect to my billing data from GCP Big Query, but I can't use the value !



Community Support
Community Support

Hi @cgeorgeot ,


Seems a bit tricky, what exactly do you mean by Google data loss? Are you making sure that the billing data is connected to BigQuery?

You can refer to the following document about how powerbi desktop connects to data in big query.

Power BI with the Google BigQuery BILLING Project as Default (

How to Connect Power BI and BigQuery Billing? | Big Data Demystified (


If the problem is still not resolved, please provide detailed error information and related operation screenshoots. Looking forward to your reply.

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors