Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How do I pull data from a Blob SQL column into PowerBI for processing?
One of our partners is sending us XML files which we store as a Blob in our tables.
I need to run some reports in PowerBI, but it would be nice to convert the Blob so its in a readable format.
Does the Parser -> XML option not work for you?
I haven't used blobs, but assuming you can get it in as text, you can clean it up in Power Bi.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
17 | |
11 | |
5 | |
4 | |
3 |