Power BI & GCP Big Query Mix of issues & suggestions

[Bamak]

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)

[Christophe93]

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

[v-lili6-msft]

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