Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Juerg
Regular Visitor

Last three digits of phone numbers masked after import

Hi,

 

I downloaded the Teams Call statistics from the teams admin portal and try to build a report on call history. 
In the .csv file, the caller numbers are visible in clear text. After the import to the PowerBI query editor (same also applies to Power Query Editor), the last three digits of the phone number are replaced by ***.

 

I need the full number in the report. Is there a way how I can stop PowerBI/PowerQuery from replacing the last three digits?

 

Before the import, full number is stored in the CSV

Juerg_0-1624008154664.png

 

After the import, last three digits are replaced

Juerg_2-1624008283325.png

 

Thanks for your help!

Jürg

1 REPLY 1
amitchandak
Super User
Super User

@Juerg , check there might some steps added in power query to do that. I so remove that step.

 

Or Advance editor in power query for table and check for all steps

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.