TrustRadius: an HG Insights company

Google BigQuery vs. Microsoft Power BI

Save this comparison

Save this comparison

Google BigQuery

277 Reviews and Ratings

Microsoft Power BI

1,906 Reviews and Ratings

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Google BigQuery

    Score8.4 out of 10
    		N/AGoogle's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.

    $6.25

    per TiB (after the 1st 1 TiB per month, which is free)

    Microsoft Power BI

    Score8.6 out of 10
    		N/AMicrosoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.

    $10

    per month per user

    Pricing
    Google BigQueryMicrosoft Power BI
    Editions & Modules
    Standard edition
    $0.04 / slot hour
    Enterprise edition
    $0.06 / slot hour
    Enterprise Plus edition
    $0.10 / slot hour
    No answers on this topic
    Offerings
    Pricing Offerings
    Google BigQueryMicrosoft Power BI
    Free Trial
    YesYes
    Free/Freemium Version
    YesYes
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Google BigQueryMicrosoft Power BI
    Considered Both Products
    Google
    Umang Aggarwal
    Customer Insights Manager in Marketing at Comcast (Telecommunications, 10,001+ employees)
    Chose Google BigQuery
    I have used most of the data analytics platforms. Based on my work, I have found that the user interface of Google BigQuery is simple to navigate. I like the front view - ease of joining tables, and integration with other platforms.
    Incentivized
    Verified User
    Chose Google BigQuery
    Google BigQuery i would say is better to use than AWS Redshift but not SQL products but this could be due to being more experience in Microsoft and AWS products. It would be really nice if it could use standard SQL server coding rather than having to learn another dialect of …
    Incentivized
    Verified User
    Chose Google BigQuery
    Other locally hosted solutions are capable of providing the required level of performance, but the administration requirements are significantly more involved than with BigQuery. Additionally, there are capacity and availability concerns with locally hosted platforms that are a …
    Incentivized
    Verified User
    Chose Google BigQuery
    Google BigQuery of course collects a much much larger array of raw data and can handle (practically) an unlimited amount of data. For a large enterprise like ours that relies on large-scale analytics, this is absolutely imperative. Google BigQuery can also combine GA4 data with …
    Incentivized
    Liz Brandon
    Sr Manager Performance Analytics in Information Technology at Beam Suntory (Consumer Goods, 501-1000 employees)
    Chose Google BigQuery
    Google BigQuery works similarly to AWS. We ended up going with Google BigQuery due to contractual restrictions imposed by one of our customers.
    Incentivized
    Francois Salvert
    Web Analytics and Dashboarding in Marketing at Blue Cross (Insurance, 201-500 employees)
    Chose Google BigQuery
    PowerBI can connect to GA4 for example but the data processing is more complicated and it takes longer to create dashboards. Azure is great once the data import has been configured but it's not an easy task for small businesses as it is with BigQuery.
    Incentivized
    Microsoft
    Verified User
    Chose Microsoft Power BI
    After several years using Google Looker Studio and BigQuery, Microsoft Power BI is a step-up in terms of visualizations. It is also much more powerful, leading to less errors and has a more intuitive interface. Looker Studio has a focus on Google Analytics whereas Microsoft …
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Features
    Google BigQueryMicrosoft Power BI
    Database-as-a-Service
    Comparison of Database-as-a-Service features of Google BigQuery and Microsoft Power BI
    Feature
    Google BigQuery
    8.4
    71 Ratings
    Microsoft Power BI
    -
    Ratings
    Automatic software patching8.017 Ratings00 Ratings
    Database scalability9.270 Ratings00 Ratings
    Automated backups8.524 Ratings00 Ratings
    Database security provisions8.664 Ratings00 Ratings
    Monitoring and metrics8.066 Ratings00 Ratings
    Automatic host deployment8.013 Ratings00 Ratings
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Google BigQuery and Microsoft Power BI
    Feature
    Google BigQuery
    -
    Ratings
    Microsoft Power BI
    8.8
    140 Ratings
    Pixel Perfect reports00 Ratings8.5120 Ratings
    Customizable dashboards00 Ratings10.0140 Ratings
    Report Formatting Templates00 Ratings8.0128 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Google BigQuery and Microsoft Power BI
    Feature
    Google BigQuery
    -
    Ratings
    Microsoft Power BI
    8.2
    140 Ratings
    Drill-down analysis00 Ratings7.0139 Ratings
    Formatting capabilities00 Ratings9.0138 Ratings
    Integration with R or other statistical packages00 Ratings8.0103 Ratings
    Report sharing and collaboration00 Ratings9.0135 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Google BigQuery and Microsoft Power BI
    Feature
    Google BigQuery
    -
    Ratings
    Microsoft Power BI
    8.6
    134 Ratings
    Publish to Web00 Ratings8.0129 Ratings
    Publish to PDF00 Ratings9.0122 Ratings
    Report Versioning00 Ratings9.0102 Ratings
    Report Delivery Scheduling00 Ratings8.0104 Ratings
    Delivery to Remote Servers00 Ratings9.074 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Google BigQuery and Microsoft Power BI
    Feature
    Google BigQuery
    -
    Ratings
    Microsoft Power BI
    8.7
    136 Ratings
    Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings9.0131 Ratings
    Location Analytics / Geographic Visualization00 Ratings8.0122 Ratings
    Predictive Analytics00 Ratings9.0102 Ratings
    Pattern Recognition and Data Mining00 Ratings9.01 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Google BigQuery and Microsoft Power BI
    Feature
    Google BigQuery
    -
    Ratings
    Microsoft Power BI
    8.6
    127 Ratings
    Multi-User Support (named login)00 Ratings9.0121 Ratings
    Role-Based Security Model00 Ratings9.0102 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)00 Ratings10.0111 Ratings
    Report-Level Access Control00 Ratings7.01 Ratings
    Single Sign-On (SSO)00 Ratings8.394 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Google BigQuery and Microsoft Power BI
    Feature
    Google BigQuery
    -
    Ratings
    Microsoft Power BI
    8.0
    117 Ratings
    Responsive Design for Web Access00 Ratings8.0111 Ratings
    Mobile Application00 Ratings7.793 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile00 Ratings7.7112 Ratings
    Application Program Interfaces (APIs) / Embedding
    Comparison of Application Program Interfaces (APIs) / Embedding features of Google BigQuery and Microsoft Power BI
    Feature
    Google BigQuery
    -
    Ratings
    Microsoft Power BI
    8.4
    80 Ratings
    REST API00 Ratings8.072 Ratings
    Javascript API00 Ratings9.956 Ratings
    iFrames00 Ratings8.055 Ratings
    Java API00 Ratings8.046 Ratings
    Themeable User Interface (UI)00 Ratings8.163 Ratings
    Customizable Platform (Open Source)00 Ratings8.444 Ratings
    User Ratings
    Google BigQueryMicrosoft Power BI
    Likelihood to Recommend
    8.6
    (71 ratings)
    8.5
    (142 ratings)
    Likelihood to Renew
    8.1
    (3 ratings)
    9.0
    (2 ratings)
    Usability
    7.7
    (5 ratings)
    7.9
    (58 ratings)
    Support Rating
    7.3
    (10 ratings)
    10.0
    (53 ratings)
    Implementation Rating
    -
    (0 ratings)
    9.0
    (1 ratings)
    Contract Terms and Pricing Model
    10.0
    (1 ratings)
    -
    (0 ratings)
    Data Sharing and Collaboration
    -
    (0 ratings)
    8.5
    (82 ratings)
    Data Sources
    -
    (0 ratings)
    9.0
    (81 ratings)
    Professional Services
    8.2
    (2 ratings)
    -
    (0 ratings)