Clarity

 View Only
  • 1.  Timesheet Report With Power BI

    Posted Sep 06, 2019 10:07 AM
    Hi,
    We have some problems to create a new TimeSheet report in Power BI, using ODATA connection, because we don't see the hour that the user set day by day. We connect to the DWH in JASPER and this atribute appear, but in power bi no. I attach some screenshots to can understand our problem.

    If anyone can help us, I would be gratefull.
    Best regards.
    Patricio.







  • 2.  RE: Timesheet Report With Power BI
    Best Answer

    Posted Sep 09, 2019 10:27 AM
    Hi Patricio,
    ODATA is a copy of the DWH database. Calculated fields are not available as columns in the database and hence missing in the data imported to Power BI. You might need to create the same calculated field again in Power BI.

    Kind Regards
    Senthil