Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
After the import, last three digits are replaced
Thanks for your help!
Jürg
@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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |