A way to display dataset error message

[sneidercub]

Hi everyone,

I was wondering if there is a way to show a label within a report when the dataset refresh failed?

When this happens the report usually just keeps showing the last data available, data for the last time the refresh was successfull.

Please help or let me know if there is a workaround to advise the users, something like: "Data refresh is currently unavailable"

[R1k91 · Accepted solution]

uhm... only idea I get is calling APIs I don't know if it works for your scenario but you could try...

I'm thinking to call the Power BI API to get refresh history for the dataset.

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history#completed-refresh-e...

keep in mind you can't call them natively at run time and using PQ in the same dataset refresh will only give you the history before the current refresh.

you could create another report that calls the apis for all the needed dataset and shows the result of these apis calls refreshing its dataset on-demand.

more experimental (I implemented this on a customer) calling APIs in realtime trough a caller like paginated reports.

https://medium.com/riccardo-perico/interactive-api-calls-from-power-bi-report-3e488ca8ffb6 

[sneidercub]

Thank you! I'll review this approach

[R1k91]

showing the last datetime refresh is not an option?

[sneidercub]

Hi, thank you for your answer,

In this report I'm already showing the last time the report was refreshed, but the customer also wants to see explicit if there is an error or the schedule refresh failed.