Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I’m struggling trying to build a set of reports on a datazen generated from the stream analytics example. I figured out how to work with azure blob data (it wasn't as easy as I hoped - parsing errors, but I made it work after a bunch of transformations)., I’m struggling with what should be a simple task. I want to parse the date so that I can build some time-based reports. The date format as returned from the json stream is this: 2015-10-14T23:29:10.0000000Z
1) I tried to do a datevalue on this and I get a format error.
2) I parsed it manually and then tried a datevalue function on 2015-10-14 23:29 and I still got an error.
Any advice to coax power bi to recognize this as a date?
Thank you,
Dan
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |