cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbihelp87 Frequent Visitor
Frequent Visitor

Power BI Add timestamp for webdata and append data

My source is a Web URL.  It is updated twice a day with data (historical data is not available, its new data everyday)

 

Basically what I am looking to do is schedule a Power BI refresh twice a day.  Each time I refresh and new data is added I wanted the a column indicating the date and time. Then later in the data for the second refresh the new data is appended to the first refresh and also indicates the date/time it is added in Power bi

 

The weblink is only reporting new data but my query in Power BI will be growing and indicating the date/time rows were added in powerbi.  I am not sure if this is possible in PowerBI without other tools!

2 REPLIES 2
Community Support Team
Community Support Team

Re: Power BI Add timestamp for webdata and append data

Hi @powerbihelp87 ,

 

I think it's possible to show you the last refresh time in power bi , please kindly refer: 

Show it in the tile: https://community.powerbi.com/t5/Desktop/Automatically-adding-date-for-last-refresh-of-data/td-p/751...

Show it using query editor: https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/

 

But based on research, it's not accessible to indicate the data added.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
powerbihelp87 Frequent Visitor
Frequent Visitor

Re: Power BI Add timestamp for webdata and append data

Thank you for responding! I have been searching and do not see a way to add when each specific row was added into Power BI. 

 

I know there is a way to show the most recent date but the user is looking to spot what time each row is added.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 39 members 1,046 guests
Please welcome our newest community members: