Forum Discussion
Last Refreshed Date with Synapse CUBE as Data Source
Community SupportHi Anonymous
You can create a calculated table with DAX Table = {NOW()} and display this datetime value in your report to show the last refreshed time. A calculated table is only evaluated when it's created or the data is refreshed. When you publish the report to Power BI Service, it will show UTC time there. So if your time is not UTC time, try adding/subtracting the offset hours like {NOW() + 6/24}.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Once connected to the Cube, only new and quick measures are available. See below my screen shot. The solution provided wouldn't work in this scenario. Is it possible to solve it by using either the new or quick measure? Keep in mind that blank query and advanced editor are not available either.
Thanks,
- v-jingzhang
Hi Anonymous
What data source is it and which data connector do you use to connect to it?
Which connection mode do you use to connect to this data source?
From your description and screenshot, it looks like you are using Live Connection mode to connect to this data source. If so, it will always query data from the data source directly. We can think it is using live data so there is no need to add a "Last Refreshed Date" to the report. A "Last Refreshed Date" is usually added when we use Import mode and refresh data manually or automatically.
Best Regards,
Jing