Only able to see public Google Big Query NOT my Google Big Queries

[DarnelMooreTFA]

Hello:

I upgraded my PowerBI desktop, was able to connect to GBQ however i'm only seeing publicly available data vs. my personal google big query.

Could you please provide a status and/or guidance?  I am in the middle of a big data analysis and this information is crucial to my presentation.

Thanks in advance and look forward to hearing from you.

Best,

Darnel

[Anonymous]

I know this is an old post but putting this comment for future references. I faced similar issue when I install PowerBI app from Microsoft Store. I uninstalled it and downloaded .exe installer. I didnt face this issue in manual setup of PowerBI. Make sure you have proper permissions set on GCP and Bigquery datasets so that they can be viewed in PowerBI desktop. Most of the times this can be a version issue.

[Anonymous]

@DarnelMooreTFA,

Do you use Power  BI Desktop July release(2.60.5169.4101)? I am unable to reproduce this issue in the Power BI Desktop version. I would recommend you check if there are improper settings in Google Bigquery.

Regards,
Lydia

[DarnelMooreTFA]

Hi Lydia:

Thanks for getting back to me, much appreciated.  I have the updated July release installed.  What settings within GBQ would need to be enabled.  Thanks in advance for your help.

Best

Darnel

[Anonymous]

@DarnelMooreTFA,

Add a blank query in Power BI Desktop and paste the following code into Advanced Editor of the blank query, then check if you get any error.

let
    Source = GoogleBigQuery.Database(null),
    #"project-data" = Source{[Name="yourprojectname"]}[Data]
  in
    #"project-data" 

Regards,
Lydia