Forum Discussion

ianallen13's avatar
ianallen13
Helper I
4 years ago
Solved

Replace created date field

Hello,    I uploaded an excel file with records yesterday into SharePoint and it all worked out nicely, except for the created field now shows 1/5/2022 for all records.  When I open Power Bi and op...
Need Help
Tips and Tricks
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, ianallen13 

    Load your Excel file into PBIX, use the merge query, match the case numbers, click OK, and then expand Create Time Column.

    Please refer to the attachment below for details. Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, ianallen13 

Load your Excel file into PBIX, use the merge query, match the case numbers, click OK, and then expand Create Time Column.

Please refer to the attachment below for details. Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.