Connect BigQuery with Power BI- Best Practice and Cost Effective way

0 votes
Cost Effective way to connect Google BigQuery with Power BI. What intermediate layer is required in between GCP and Power BI?
Feb 25 in Power BI by surbhi
• 3,810 points
533 views

1 answer to this question.

0 votes
You can use a custom query or load the entire table to access BigQuery straight from DataStudio. Between BigQuery and DataStudio, nothing is technically required.

In terms of best practices, if your dashboard reads a lot of data and is utilized frequently, it can cost a lot of money. In this scenario, a "layer" is appropriate. If this is the case, you could pre-aggregate your data in BigQuery to prevent having DataStudio read a large quantity of data many times.

My recommendation is as follows:

Create a process (it might be a scheduled query) that aggregates your data on a regular basis and saves it in a different database.
Read your data from the aggregated table in DataStudio.
These measures can help you save money while also making your dashboards load faster. The disadvantage is that unless you run the aggregation process very frequently when working with streaming data, you will not be able to view the most recent registries.
answered Feb 27 by CoolCoder
• 4,360 points

Related Questions In Power BI

0 votes
1 answer

I have a web API with basic authorisation and username and password. How do i connect to it in Power BI?

Hey, @There, I found your query is quite ...READ MORE

answered Oct 29, 2020 in Power BI by Gitika
• 65,890 points
2,014 views
0 votes
1 answer

how can I connect my web api with Power BI Reports?

Go to Home > Edit Queries > ...READ MORE

answered Oct 18, 2018 in Power BI by Annie97
• 2,160 points
8,338 views
0 votes
0 answers
0 votes
1 answer

How to connect Github with power BI?

There are few steps which we need ...READ MORE

answered Nov 19, 2020 in Power BI by Gitika
• 65,890 points
371 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
663 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
1,971 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,570 points
709 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,350 points
868 views
0 votes
1 answer

Power BI not able to connect to Azure SQL with private end point

You'll need to install an on-prem gateway ...READ MORE

answered Feb 17 in Power BI by CoolCoder
• 4,360 points
2,181 views
0 votes
1 answer

Autorefresh the Power BI report with import Query

You should publish the report from the ...READ MORE

answered Feb 10 in Power BI by CoolCoder
• 4,360 points
56 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP