Forum Discussion

connork's avatar
connork
Frequent Visitor
9 years ago

Calculated Columns on Direct SQL Connection

I have two SQL tables with data on employee's time:   Table A: Daily snapshot of the total time each employee entered on his timecard for that day (i.e. one record would be a full 8.0 hr day).  Ea...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi connork,

 

Could you try combining the tables in the SQL used for the DQ table?

 

 

  • connork's avatar
    connork
    Frequent Visitor
    9 years ago

    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

     

     

    • v-sihou-msft's avatar
      v-sihou-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      connork

       

      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,

      • connork's avatar
        connork
        Frequent Visitor
        9 years ago

        v-sihou-msft

         

        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?