How To Mask Sensitive Data In Power BI

[@EnterpriseDNA]

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
Learn more about Enterprise DNA - www.enterprisedna.co/
Enterprise DNA Membership - enterprisedna.co/membership
***** Related Links *****
Power BI Query Parameters: Optimizing Tables - blog.enterprisedna.co/optimizing-power-bi-tables-using-query-parameters/
Turning Calendar Type Layout Into Tabular Format In Power BI Using Query Editor - blog.enterprisedna.co/turning-calendar-type-layout-into-tabular-format-in-power-bi-using-query-editor/
Creating A Dynamic Date Query Table In Power BI: A Query Editor Tutorial - blog.enterprisedna.co/creating-a-dynamic-date-query-table-in-power-bi-a-query-editor-tutorial/
***** Related Course Modules *****
Best Practices & Feature Reviews - portal.enterprisedna.co/p/best-practices-feature-reviews
Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
Advanced Data Transformations & Modeling - portal.enterprisedna.co/p/advanced-data-transformation-and-modeling
***** Related Support Forum Posts *****
Excel Add In - To Create Random Data - forum.enterprisedna.co/t/excel-addin-to-create-random-data/9144
Cost Allocation - Help! - forum.enterprisedna.co/t/cost-allocation-help/9296
Count Number Of Clients Lookup Table - forum.enterprisedna.co/t/count-number-of-clients-lookup-table/8971
For more data masking queries to review see here…. - forum.enterprisedna.co/search?q=data%20masking

[@minathanh7072]

I have a question: How can you make it look so cool, the Customer ID and Name columns in the data model, 5:13 in the vid. Thank you!!!

[@EnterpriseDNA]

Hello mina,
We're not sure about what's your query here. You can reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful! If you haven't yet, you can subscribe to our RUclips channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
www.linkedin.com/groups/12004506/

[@ankitjain3280]

Great Tips Brian.

[@SandipanSarkar-c8v]

Finished watching

[@cristian.angyal]

Great tips Brian. Thanks for sharing!

[@samuelmanseau6905]

Very clear & useful ! great thanks for this video !

[@EnterpriseDNA]

Amazing tips Brian. Nice work

[@jamiebright8347]

Very useful information Brian, many thanks!!

[@BB-tn3ru]

How would you anonymize the customer id to the same index number for a given customer id across power queries to enable the datamodel to work after the anonymized customer account numbers ?

[@EnterpriseDNA]

Hi, several topics have been raised on anonymizing data in Power BI inside the Enterprise DNA Forum. You may check the posts here: forum.enterprisedna.co/search?q=anonymize

[@nikokatsantonis1664]

Wouldnt this ruin the current PBIX File. For instance, I want to do this but my PBIX file for client is active and used so I how can I make a copy?

[@EnterpriseDNA]

Hello Niko Katsantonis,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
Well, just copy the current version of the PBIX file and then paste it. By this way, you'll generate a copy file and then you can perform all the transformations as showcased in the video in order to mask the sensitive data.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful! You can subscribe to our RUclips channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
www.linkedin.com/groups/12004506/

[@PutltOnWax]

Excellent video!

[@AjaySingh-ll5qw]

Nice...

[@mygame2368]

If we do data masking on sales data we r losing data by removing alternative rows ..what is the solution for this

[@EnterpriseDNA]

Hello MY Game,
Thank you for question. We appreciate your time.
Well, you may ignore that step, if required, if you feel that by performing this transformation your data is losing the main context and apply the remaining sets of transformations.
For more queries, you can also reach out to us through our Community Forum where our members as well as Experts Team will be able to assist you, in a better and efficient manner.
I hope this helps.
Please make sure that you're subscribed to our RUclips channel so you don't miss out any updates regarding Power BI. Along with it, you may also be interested to join our Power BI group on LinkedIn to receive latest updates. Links provided below for your reference.
Happy Learning!!!
Thanks and Warm Regards,
Enterprise DNA
forum.enterprisedna.co/
ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
www.linkedin.com/groups/12004506/

[@Su-ec7pj]

Great video (y)

[@Anilkumar-qk2nb]

Mr. Sam Mckay ?