On the article Automating table refresh in Power BI I explained many methods to automate refresh of individual objects, which could be tables or partitions.
This creates the need of good ways to visualize the last refresh date and time for each partition and table. The portal shows the refresh date/time for the entire dataset, we can’t identify on the Power BI portal the exactly date for each table last refresh.
The Tabular Editor, famous 3rd part tool to manage Power BI models, is very powerful. It implements a c# execution engine inside it, allowing us to create scripts, from small scripts to very powerful ones.
One example is the Processing Manager published on Elegant BI blog. It creates a powerful C# program to generate refresh script for a set of objects in the model.
Based on this example, I created a C# program to visualize the last refresh date/time for each partition. It’s published on Github, you can copy the LastRefresh.cs code and execute it on the Advanced Scripting window in the Tabular Editor.
The result is like the image below. You will be able to see the last refresh date/time for each partition. I hope this tool is useful if you are customizing the refresh of the objects. You are also invited to improve this tool.
Some future improvement possibilities:
- Join this tool with the Processing Manager, calling them from a single main form.
- Make these tools an independent application
- Improve the design of the form