Forum

Power BI Interview ...
 
Share:
Notifications
Clear all

Power BI Interview Questions & Answers: Exporting Data with Timestamp in File Name

1 Posts
1 Users
0 Reactions
537 Views
Posts: 9
Topic starter
(@Sanjeev)
Joined: 6 months ago

“Scenario 1 – Suppose you have a dashboard published on the Power BI service workspace. When you export the data, it automatically saves as xyz.xlsx. If you want to add a timestamp to the filename, what changes will you make in the report or process?”

In many Power BI projects, exporting reports and data is a common requirement. A frequent interview scenario is:

“You have a dashboard published on the Power BI Service workspace. When you export the data, it automatically saves as xyz.xlsx. If you want to add a timestamp to the filename, what changes will you make in the report or process?”

This type of question tests both your technical understanding of Power BI limitations and your ability to suggest practical solutions.


Key Concept

By default, Power BI does not allow you to customize exported filenames directly within the Power BI Service. The exported file names follow a standard naming convention (report name or dataset name).

To add a timestamp to the exported file name, you need to implement workarounds outside the Power BI Service.


Possible Solutions

1. Use Power Automate Integration

  • Create a Power Automate flow that triggers when a user exports or schedules a report.

  • Configure the flow to rename the exported file with a timestamp (e.g., SalesReport_2025-09-09.xlsx).

  • Store the renamed file in OneDrive, SharePoint, or a preferred folder.

2. Use Paginated Reports

  • If your organization uses Power BI Paginated Reports, you can define custom file names with expressions.

  • In the export settings, configure an expression like:

    ="SalesReport_" & Format(Now(),"yyyyMMdd_hhmm") & ".xlsx"
    
  • This ensures every export carries a timestamp automatically.

3. Script-Based Approach

  • For advanced scenarios, use Power BI REST API or Python/Powershell scripts.

  • Schedule a job that pulls report data using APIs, exports it to Excel/CSV, and appends a timestamp to the file name before saving.


Sample Interview Answer

"By default, Power BI Service does not allow dynamic file naming while exporting reports. To achieve this, I would recommend using Power Automate to rename the exported file with a timestamp before saving it. If the project uses Paginated Reports, I can add a date-time expression in the export configuration to include timestamps in the file name. In more advanced use cases, I can use Power BI REST APIs or scripting solutions to automate exporting and timestamping. This ensures consistency, automation, and better file tracking for the business."


Key Takeaway

This question tests whether you understand Power BI’s limitations and can suggest workarounds using Power Automate, Paginated Reports, or APIs. A strong answer shows both technical depth and practical problem-solving skills.

 


Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: