Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have two SQL tables with data on employee's time:
First time working on a direct SQL connection - if I had imported I would try using a join table with filter & earlier functions... but they do not seem to be available with calculated columns (and I'm not sure if this a PBI limitation or just my knowledge limiting the functionality).
Any suggestions on how to combine these datasets so that I can show a matrix with the dates as columns & jobs as rows?
Thanks
@Phil_Seamark - I don't have write-access to our SQL database, so I'm trying to understand the limitations of what I can do in PowerBI without going into other systems.
Am I (already) at a dead-end using the PowerBI route?
Thanks
I still understand the issue when you encountered in import mode. However, in this scenario, I think you can import those two tables individually. Then you can use "Merge Queries" in Query Editor to join tables based on the Time ID column.
Then expand the related table into rows.
Regards,
Thanks Simon that worked! New to merge queries, and I had been using it incorrectly.
I have been working with our IT team to try the route of joining in the SQL tables, and made progress that way as well.
Any pros/cons on direct query vs scheduled refresh through the gateway?
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |