Showing results for 
Search instead for 
Did you mean: 

Power BI & GCP Big Query Mix of issues & suggestions


According to fix or improve PBI/Big query relationships (native connector , SSO Direct query from service etc...)

some ideas :


  • Power query & Biq query native connexion :  bug in case of left join on columns in nullable mode (***)
  • Possibility of being able to enter a SQL query directly (***) <- may solve the previous case & open to BI modelers preferring to handle SQL for transformations
  • Big Query  table / view column name must be different from the view name otherwose issue on power Query (**)
  • Allow direct query SSO between power BI service & big query (*) <- strong security constraints at the RLS source carried by BQ
  • Possibility in power query (desktop & dataflow) to view the native query transmitted to the Big Quey backend (query folding)
Status: New
New Member

Thanks Bamak , it's just what we need regarding Big Query  PBI  integration 

Community Support


Thank you for your feedback and suggestions, you could submit them in power bi idea forum.


then vote for them to make it coming soon.