BigQuery & Power BI Integration Issue

[TitikshaGanjoo]

Hi All,

The projects created on BigQuery are not appearing on Power BI, can someone help as to why the relevant data set is not appearing for establishing a connectiion between the two.

Please refer to the screenshots.

Regards,

Titiksh

[Anonymous · Accepted solution]

@TitikshaGanjoo,

Do you create the project by yourself?I can see the newly created project in Power BI Desktop navigator.

Please add a blank query in Power BI Desktop, copy and paste the following code into Aadvanced Editor of the blank query and check if you can connect to the project data. Also make sure that you use Power BI Desktop August 2018 version.

let
    Source = GoogleBigQuery.Database(null),
    #"project-data" = Source{[Name="YourprojectID"]}[Data],
   dataset_Schema = #"project-data"{[Name="Yourdatasetname",Kind="Schema"]}[Data]
   in
    dataset_Schema

Regards,
Lydia

[Anonymous]

Hello,

I might have some information to help resolve the issue in the back end.

I couldn't connect powerbi with bigquery when the data was located in region eu-west2 but worked fine when in the multiregion EU.

What is more, the queries from powerbi appear succesful in bigquery.

My guess is their an issue with a parser probably to du with the '-' character.