Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
TitikshaGanjoo
Frequent Visitor

BigQuery & Power BI Integration Issue

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,

TitikshBigQuery Screenshot.pngPBI screenshot.png

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors