Not able to refresh report in Power BI service. about ccoinsights

[github-actions]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[github-actions]

This issue was closed because it has been stalled for 5 days with no activity.

[josunefon]

Hi @rajatbhamare, the current dashboard doesn't support Power BI Online. However, there's one solution that supports that in the early adopters backend branch

[francesco1119]

None of the CCO dashboards can be refreshed?
So what's the point then?

There is no point to publish the dashboard if in 1 week time I'm showing outdated data.
It's a pity that Microsoft, after all this work, cannot do the extra mile and create a refresh.

[francesco1119]

@josunefon , as you labelled this as "help wanted" I want to give you an help and find a way out.

Do you think this scenario might be a valuable solution:

1. Save the dashboard as a .pbix locally and setup a cron job that trigs a Powershell script that refresh the whole thing.
2. Forcefully refresh the data set (always with cron job)
3. Setting up a refresh button within the dashboard
4. Power Automate flow

Do you think some of these might work or are they all out of scope?

[josunefon]

Hi @francesco1119 ,

First and foremost, these dashboards (Governance and Infrastructure) use dynamic data sources, a feature not currently supported in Power BI Online at the time of dashboard development. Regrettably, the auto-refresh feature is unavailable due to technological limitations. Currently only directquery datasources and static endpoints are supported for auto-refresh (table with supported methods). If you look at the issues, this topic was already discussed.

Furthermore, within the early adopters_backend branch, efforts are underway to establish a static endpoint for storing all data extracted through API calls in an Azure-based storage. This initiative aims to enable the publication of the dashboard on Power BI Online, a capability already present in GitHub Contributions and Azure DevOps dashboards.

So what's the point then? This is a tool that is being used by consultants worldwide to have a clear vision about what is the overall status of the governance and infrastructure in Azure when a project starts (Plug and play).

Feel free to contribute to this initiative with the scenario that you're proposing, your efforts will be appreciated.

[bmvalente]

@francesco1119 Just to clarify, as stated in the Support document, this is community-based project that is maintained, on a best effort basis, by folks that happen to work at Microsoft. As mentioned by @josunefon, we are aware of the limitations that the current solution has, and we have been working on efforts to remove them or mitigate them. That work is not yet published in main (it still lives in its own branch) and we are working to make it public soon.