Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

ETL reporting for records with different timestamp

Hi ,

 

I have to create a power BI report which takes  data from a cube which inturn is pulling data from DB .

DB has tables with ETL loads being performed once or more per day  and each load is spread across multiple load timestamps .

 

so when I have to show a given batch grouped by the selecting the load date , i need to show loads executed for that day followed by no of records loaded for each batch .

 

I can ideally have load date being uniform across all the load but the DB currently only holds load timestamp values that are different and I dont want to make changes at the DB level and handle is only at power BI level.

 

could you please help 

1 Reply

  • Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?