cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI & GCP Big Query Mix of issues & suggestions

Hi,


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
Comments
Christophe93
New Member

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

v-lili6-msft
Community Support

hi  

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

https://ideas.powerbi.com/ideas/

 

then vote for them to make it coming soon.

 

 

Regards,

Lin