Forum Discussion

gemcityzach's avatar
gemcityzach
Icon for Helper IV rankHelper IV
2 years ago

Data Last Refreshed Card synced with PowerBI Service refresh history

Hey folks,   I developed a report on the desktop that is synced to four SharePoint lists as the query sources. On the report I have a "Data Last Refreshed" card that updates itself when the entire ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi gemcityzach 

 

Much thanks to Anonymous  for the prompt replies. SharePoint lists currently only supports Import connection. You can vote up the idea Microsoft Idea: Direct Query for SharePoint List 

 

May I know how you create the "Data Last Refreshed" card? How did you get the last refreshed date stamp? There is a common practice to add the latest refresh time to a report, you can refer to Add last refresh date based on a Power BI or OData query section in Add last refresh date to a Power BI report - Azure DevOps | Microsoft Learn 

 

Usually this won't be a problem. Ideally the report will be updated with latest data shortly after a refresh completes in the service. If you refresh the report visuals manually, will you see the "Data Last Refreshed" card updated? 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

gemcityzach's avatar
gemcityzach
Icon for Helper IV rankHelper IV
2 years ago

Hi Jing. That method you pasted is essentially what I did. The refresh date stamp only updates when manually refreshing all of the table queries. While the service will trigger and refresh all of the table queries, it somehow does it without updating the refresh card.