Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Is there any way to display the refresh date of a published PBI dataset in a report? The PBI dataset is not refreshed everyday, but the requirement is to show users the last refreshed date of the data. The option to display refresh date using blank query does not work because I cannot create a blank query when connecting to a PBI dataset. I saw another post where the suggestion was to create a tile in a Dashboard, but that does not fit my requirements. Is there any way to do this? Appreciate your suggestions!
Solved! Go to Solution.
Hi, @newpbiuser1_23
Sorry. As of now ,you cannot add additional queries to the data source to get the last refresh time as your data source is "dataset", which belongs to the connection mode of liveconnect.
If you are the owner of the original data model, you can consider adding a calculated column/ or a new table in M, that when loaded to the model will give you the refresh time.
How-to-include-the-Latest-Refresh-date-and-time-in-a-report
Best Regards,
Community Support Team _ Eason
Hi, @newpbiuser1_23
Sorry. As of now ,you cannot add additional queries to the data source to get the last refresh time as your data source is "dataset", which belongs to the connection mode of liveconnect.
If you are the owner of the original data model, you can consider adding a calculated column/ or a new table in M, that when loaded to the model will give you the refresh time.
How-to-include-the-Latest-Refresh-date-and-time-in-a-report
Best Regards,
Community Support Team _ Eason