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,
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
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |