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 All,
I am writing a report that needs to show responses by Device type an dwe only store the User Agent code e.g.
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.2; WOW64; Trident/7.0; .NET4.0E; .NET4.0C; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 2.0.50727; .NET CLR 3.0.30729; MSOffice 12)
Does any one out in Power BI land know of a function that can split this string down to show the Device or has any body else had the same problem.
Any help is much appreciated
Solved! Go to Solution.
Hi
The problem is these strings di not have a std format so to determine the device is to say the least hard.
compatible; MSIE 7.0; Windows NT 6.2 in this example the device would be Computer due to the MSIE 7.0
The other prblem is they are random to an extent and there are databases tiy can get to link to.
The reason I asked the question was if any one who had worked with User Agents had worked out a formula to get the device data without a looku p DB.
The more I read about the User Agents it seems a lookup DB may be t he way to go
Hi @Anonymous,
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.2; WOW64; Trident/7.0; .NET4.0E; .NET4.0C; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 2.0.50727; .NET CLR 3.0.30729; MSOffice 12)
Is above string a sample value of a loaded column? Which part do you want to extract from this string? Please show us your desired result.
Regards,
Yuliana Gu
Hi
The problem is these strings di not have a std format so to determine the device is to say the least hard.
compatible; MSIE 7.0; Windows NT 6.2 in this example the device would be Computer due to the MSIE 7.0
The other prblem is they are random to an extent and there are databases tiy can get to link to.
The reason I asked the question was if any one who had worked with User Agents had worked out a formula to get the device data without a looku p DB.
The more I read about the User Agents it seems a lookup DB may be t he way to go
So what part of that string do you want?
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 |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |