How to show refresh history of all datasets within a group?

[Sylvain74]

Hello,

I am building a Power BI report to monitor datasets refreshes contained in a workspace. To do so I am using the power bi service rest API and currently I am able to get list of workspaces, and list of all datasets contained in the group (workspace) specify as parameter in the API call.

There is another API called "Get Refresh History In Group" which returns the refresh history for the specified dataset from the specified workspace.

In PowerBI Desktop, instead of creating a connection and then dedicated table for each workspace/dataset pair values, I would like instead find a way to list all Refresh History for all datasets contained in the specify workspace.

Do you have any idea on how to achieve that?

Hope my explanation is clear enough.

Thanks.

[parry2k]

Thanks, @bcdobbs . Exactly what I said 🙂 Thanks for endorsing it. Cheers!!

[bcdobbs · Accepted solution]

If you take your existing call to get refresh for a single dataset and wrap it in a function as shown in https://docs.microsoft.com/en-us/powerquery-m/understanding-power-query-m-functions so that you have a function that you can pass the dataset Id to.

Then use your existing return that lists id's of datasets add a custom column and use your function to get refreshed for each row.

Custom column will initially be a table type column which you can expand in the gui to new rows.

[parry2k]

@Sylvain74 You have to iterate thru each dataset in the workspace, maybe create a PQ function, and pass dataset id to the function which will return refresh history, and then that will give you combined refresh history of all datasets.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Sylvain74]

Hi Parry2K,

That's exactly what I would do if I would working with programming language like C# or VB.Net but here in Power BI, how would you achieve that?