Encryption
Hi all, I have a doubt related to encrytion. In my company they want to encrypt some sensitive information columns, we have different databases but we created pipelines and all the information is in BigQuery, so some sensitive information columns will be encrypted in BigQuery. In my report, we use some sensitive columns in measures or relationships, my question is what are the good practices in Power Bi? I mean, should I still use this encrypt information in the measures and everything like it was or what? it is the first time so I am a bit lost. Also if for use some of them in the filters, can I decrypt it?
Unable to authorise my ODBC BIgQuery connection
Hello everyone! Need help. Use My own ReportServer, one one reports has bigquery db as datasourse. But I unable to authorise my ODBC BIgQuery connection (via Samba ODBC Driver) to configure my scheduled updates at web ui. Tried both methods as a Service Authentication and User Authentication. Getting Error Log on failed. Ensure the user name and password are correct.
Directquery limitation summarize
Hi, Context: I have a table with 7 billion rows in bigquery, the table is partitioned and clustered and performs well when sending queries. I'm trying to get the number of unique users based on a certain condition and the following SQL syntax works perfectly. SELECT COUNT(DISTINCT users) AS cnt_users FROM ( SELECT users, AVG(transactions) AS transactions FROM `project.dataset.canales` WHERE Date BETWEEN '2023-10-01' AND '2023-11-05' GROUP BY users) WHERE transactions BETWEEN 15 AND 25; The result is one row with the value and the query runs in 2-3 seconds. When translate this query to dax: light_users = VAR _users = SUMMARIZECOLUMNS ( canales[users], "avg_trx", AVERAGE ( canales[transactions] ) ) VAR _filter = FILTER ( _users, [avg_trx] >= 15 && [avg_trx] <= 25 ) RETURN COUNTROWS ( _filter ) The result in power bi is Looking at the query created by Dax in bigquery I can see that Dax created a temp table but the quantity is 1+ million records The table returns to Power BI to make the final calculation. So, How can I calculate all directly in the source and solve the problem with the returned rows? I tried using vars, without vars and nothing works for me. ThanksData source Automatic Refresh (Bigquery database)
Hi guys, I'm trying to configure automaytic refreshs in my Datasets in Powerbi Server, but in every refresh i have the same error: "ODBC: ERROR [HY000] [Microsoft][DriverOAuthSupport] (8701) Error interacting with REST API: Couldn't connect to server ERROR [HY000] [Microsoft][DriverOAuthSupport] (8701) Error interacting with REST API: Couldn't connect to server Table: " I know that this refresh alredy worked in past, but now i'm facing this issues. have you faced this error, and how did you solve it? Help please, because i'm without any ideas to solve it. thank you
