Visualizing last refresh date in power bi

data-visualization powerbi dax m
Nelson Gomes Matias picture Nelson Gomes Matias · Sep 15, 2017 · Viewed 8.2k times · Source

Is it possible to add a card in power BI that shows the last time the underneath dataset has been updated?

Many thanks!

Answer

Foxan Ng picture Foxan Ng · Sep 16, 2017

You can create a blank query and use the following M query to create a single-cell table:

let
    Source = #table(type table[Last Refresh=datetime], {{DateTime.LocalNow()}})
in
    Source

query

And then you can use the Card visual and drag in the column to show it. You can rename the field to remove the default aggregation. (It doesn't matter since there is only one row of data anyways)

result

The value will be recalculated each time the data is refreshed.

Related questions

Overlapping bar chart with multiple axis in PowerBi

I would like to have a overlapping bar chart in PowerBi with multiple axis. I have an example from Excel which I would prefer to recreate in PowerBi if this is possible. Here the example: Is this possible in PowerBi? …

Read More
How to make IPython notebook matplotlib plot inline

I am trying to use IPython notebook on MacOS X with Python 2.7.2 and IPython 1.1.0. I cannot get matplotlib graphics to show up inline. import matplotlib import numpy as np import matplotlib.pyplot as plt %matplotlib inline I have also tried %…

Read More
How do I convert a numpy array to (and display) an image?

I have created an array thusly: import numpy as np data = np.zeros( (512,512,3), dtype=np.uint8) data[256,256] = [255,0,0] What I want this to do is display a single red dot in the center of a 512x512 image. (At least to begin …

Read More