Share via

PowerBI masked phone numbers

THEODORE ZION ONG XIAN 20 Reputation points
2025-03-03T01:32:37.78+00:00

Hi everyone, I am working on a Power BI dashboard where phone numbers are displayed in a masked format (e.g., +656019****). However, our partnership team needs to see the full phone numbers so they can follow up on missed calls. Currently, Power BI is showing the numbers with asterisks, likely due to data privacy settings or transformations. How can I ensure that the full phone numbers are displayed in the report? Are there specific settings, DAX expressions, or data source permissions that I need to check? Appreciate any guidance on this! Thanks in advance.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,311 questions
0 comments
Accepted answer
  1. Rich Brooks 75 Reputation points
    2025-03-10T18:44:32.9866667+00:00

    Depends on where the masking takes place:

    Stored in the table: No way to hydrate the * to real numbers. Get with the data team and see how to get them cleartexted.

    Masked in Power Query: It is possible that there is a replace last 4 numbers are being replaced. Check for some code like Text.Start(phone, 7) & "*** * * *")

    Masked in Power BI, locate the phone DAX and see if you can generate a cleartext version of it for your partnership team.

    All of this needs to be wrapped in the considerations of privacy policies, data governance and law. Good luck with each approach!

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.