Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a some what complicated report scenario that I am attempting recreate in Power BI. I am new to the application so I am not entirely sure of the best way to accomplish this or if it's even possible. Basically I publish a report that reports on which version of an application a client is running. Unfortunately, there are 3 different version sources (databases) that are no integrated and do not share all of the same columns (but do all share a GUID) so I have to join them manully/separately by extracting the date from all 3 sources in an Excel file (3 total source files). I basically copy them into separate tabs and then have to represent the data the same "version" column by doing the following:
Version column steps
Please understand that I already know this is messy, especially being as though I've been doing this manually, but I do not have control over this at this time - i.e., please see: this is an executive's request 🙂 . I also can not connect directly to these db's so I will still be working with excel files. Has anyone done anything like this before? I have tried looking up a solution in this fourm but can't seem to find anyone who has successfully done the same kind of thing.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |