上下文
我在 PowerBI 服务中保存了一份 PowerBI 报告，其视觉效果是使用 Azure Analysis Services 实例中保存的数据模型创建的（数据模型本身是 azure 分析服务实例内的数据库）。该报告使用实时连接数据集来连接分析服务中保存的数据模型。
数据模型本身是 使用 Visual Studio 部署到 Analysis Services 实例。
数据模型的刷新是使用函数应用程序执行的，该函数应用程序具有刷新最新 3 个日分区的函数。 目前，为了查看上次刷新时间，我们转到 Azure 门户上的 Azure Analysis Services 实例并检查“修改日期”时间戳字段。
作为我阅读的一部分，我遇到了以下文章，这些文章解释了如何将“上次刷新日期”添加到 PowerBI 报告（以视觉形式）。但是，这些文章都没有具体提到将数据模型存储在 Azure Analysis Services 中的效果以及这在这种情况下是否有效。
问题
- 什么是将“上次刷新的日期时间”视觉效果引入 PowerBI 的最佳方法（如果
底层数据模型位于 Azure Analysis Services 内部，如何做到这一点？
- 上述方法看起来是否合理，或者是否需要针对我的情况进行调整？
- 也许需要采取不同的方法？
Context
I have a PowerBI report held in PowerBI services whose visuals are created using a data model held in an Azure Analysis Services instance (the data model itself is a database inside the azure analysis services instance). The report is using a live connection dataset to the data model which is held in analysis services.
The data model itself has been deployed using Visual Studio to the Analysis Services instance.
The refreshes of the data model are performed using a function app which has functions which refresh the latest 3 daywise partitions. Currently in order to view the last refresh time we go to the Azure Analysis Services instance on Azure Portal and check the "Date Modified" timestamp field.
As part of my reading I came across the following articles which explain ways in which you can add "last refreshed date" to a PowerBI report (in the form of a visual). However none of these articles specifically mention the effect of having the data model stored in Azure Analysis Services and if this would work in this case.
Question
- What's the best way to bring in a "last refreshed datetime" visual into PowerBI if the
underlying data model is inside Azure Analysis Services and how can this be done?
- Do these above methods seem plausible and or would these need adapting in my case?
- Perhaps a different approach would be required?
发布评论
评论（1）
是的，向存储 NOW() 或 UTCNOW() 函数的 AAS 模型添加计算列（或计算表）是显示刷新时间的正确解决方案。
计算列和表在刷新时计算并存储在模型中。
Yes, adding a calculated column (or calculated table) to your AAS model that stores the NOW() or UTCNOW() function is the correct solution to display the refresh time.
Calculated columns and tables are calculated on refresh and stored in the model.