Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
the problem is that I have sensitive customer information in a dataset I want to publish to the service (I.e. email and mobile numbers)
I was wondering if it is possible to create a custom Boolean type column containing the value true if the customer has an email and false if he doesn't (which is the easy part) and not import the actual email dimension so no personal data is exposed to end users.
it will also reduce dataset size 😄
thanks in advance
Solved! Go to Solution.
Yes. Do this in Power Query. Add a conditional column. If there is an email address, return true, else false, then remove the email column.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYes. Do this in Power Query. Add a conditional column. If there is an email address, return true, else false, then remove the email column.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you very much for the help
didnt know I could remove the column in a later step 🙂
Why don't you just remove the column from the dataset?
You are absolutely right, I could just remove the column in a later step
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |