Displaying Power Automate Button Trigger Timestamp in Power BI Report

[achandelkar6]

Hi Power BI Community,

I am encountering an issue with my Power BI report that is integrated with Power Automate. Specifically, I have a Power Automate button embedded in the report to export the reports in PDF format.

I would like to capture and display the timestamp when this button is triggered/exported directly within the Power BI report. Could you please provide guidance on how to achieve this or suggest any potential solutions?

Additionally, 

• In our workaround, we experimented with storing Power Automate button-triggered times in a SharePoint list. However, integrating this data into Power BI posed challenges, especially in Import Mode, requiring manual refreshes. The ideal scenario would be a seamless, real-time update of this data.

• Furthermore, we are unable to store the data directly into the original data source (Oracle Server) as we don't have access.
  
  

We are looking for something which can update the time instantly whenever we triggered (Export) the button inside the power BI only.

If you've faced a similar challenge or have valuable advice to offer, your expertise would be immensely valuable. I'm open to suggestions, discussions, or any creative workarounds you might have employed in similar situations.

Thank you all in advance for your time and assistance. Looking forward to the collective wisdom of the Power BI Community!

[christinepayton]

I would just add a step to the Power Automate flow that logs it, personally. I think the flow run data is available in the APIs somewhere, too, but it's only stored for a short period so you'd still need to record it somewhere if you want it to be kept more than a month.

It shouldn't require manual refreshes, but you're right in that it will delay updating the info in the report until the scheduled refresh time if you store it in SharePoint since you can't direct query SharePoint with Power BI. You could use one of the other direct query-able sources like a Dataverse table or SQL to store it, but keep in mind that will be a premium Power Automate license (which is not very expensive, and you only need one for the account running the refresh... but mentioning in case that's an issue).