Forum Discussion
Loading data to power bi from Google bigquery table with policy tags applied on PII elements
Community SupportHi, Anonymous
Do you use google bigquery connector to connect? It can use custom sql query. You can try it:
I am aware that we can write custom sql,but we don't want business user to do that and it will be difficult for end users to write sql query.
But my concerns is that in Tableau it allows to load the bigquery table with column level security,it errors only when you try to use the secured field for reporting and most useful part it allows us to create report with all other fileds of the table except the secured ones.
In power bi it's like a show stopper,it does not allow to load anything if we apply column level security on any fields in bigquery table and it's not the expected behavior and very dissapointing.Please suggest if there are any other suggestions apart from writing custom sql and creating separate views in GCP excluding the secured fields of the table (Google cloud platform).
- v-janeyg-msft
Anonymous
It seems that there is no other way. Probably because Powerbi has stronger protection for data security. Forum may not help you much.
If you have good ideas, You can submit your idea here. Hope it will come true soon.
Best Regards,
Community Support Team _ JaneyThanks for your prompt response and i will submit this idea.