Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
@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
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.