One option to achieve this is to use a DAX formula to create a calculated column that concatenates the desired date/time value with the existing data. This calculated column can then be used in the report to display the date/time information.
Here's an example of how to do this:
- Create a calculated column: In Power BI Desktop, go to the "Modeling" tab and select "New Column." Enter a name for the calculated column, such as "Date/Time," and enter the following DAX formula:
=TEXT(NOW(), "MM/DD/YYYY HH:MM:SS")
- Use the calculated column in the report: Go to the "Visualizations" pane and add the calculated column to the report. This will display the date/time information in the report.
This approach will allow the user to append a timestamp or date to their Power BI report when using a standard subscription.