Can´t connect to Big Query

[Nuc_data]

Hello all,

i am trying to connect Power BI to Big Query. I have created in BQ a table that fetchs data from a google sheet, i can do queries just fine. I have tried to log with my account and also with the service account and JSON key, i connects just fine but when i go to my tables it does not show anything, like its empty.

pago_profesores is the dataset but when i click it, it does not show my table.

[Anonymous]

Hi @Nuc_data ,

You can refer the following links to connect to Google BigQuery in Power BI Desktop:

Google BigQuery connector - Power Query | Microsoft Learn

Power BI BigQuery Connection Step by Step in 2023 | Coupler.io Blog

There could be several reasons why the dataset 'pago_profesores' did not load data from BigQuery into Power BI:

• Access permissions: Make sure you have the correct access permissions to the BigQuery dataset.
• Check for support: Ensure that Power BI supports the type of table you’re trying to connect to. For instance, as of 2020, Power BI did not support BigTable external tables.
• Data consistency: BigQuery does not guarantee data consistency for external data sources. Changes to the underlying data while a query is running can result in unexpected behavior.
• Software version: Make sure you are using the latest version of Power BI Desktop.

In addition, please check if it hit any limitation to cause the data not loading...

Limitations and considerations

How to Fix Data Not Showing Up in Power BI - Monocroft

Best Regards