New Upload weather data from web services into TM1/Planning Analytics — Read the post →

☁️ Publishing Reports to the Power BI Service

Building a report in Power BI Desktop is only the first step. To share it with the wider organisation, the report has to live in the Power BI Service — Microsoft's cloud-hosted version of Power BI. This is where PowerConnect's real value becomes obvious: published dashboards stay connected to TM1, and the data inside them can be refreshed from the cloud, on demand or on a schedule.

Refresh TM1 data online, from the Power BI Service

Once a report is published to the Power BI Service, PowerConnect keeps it connected to TM1. You can trigger a refresh from the cloud — no need to open Power BI Desktop, no need to be on your laptop. The dashboard reaches back to TM1 and pulls the latest values directly from the source.

Reviewers and dashboard consumers see live, up-to-date Planning Analytics data — the same numbers driving the planning cycle — without anyone having to manually export, copy, or rebuild reports.

Schedule refreshes with native Power BI Service features

Because PowerConnect refreshes operate through the Power BI Service, you can use the Service's own scheduled refresh feature to keep dashboards current automatically. Set it once and the dashboard refreshes on the cadence you choose — every morning before the team logs in, every hour during reporting periods, or whatever fits your business rhythm.

This is a real advantage over connectors that only work in Power BI Desktop: scheduled refresh means the dashboards your stakeholders open are always already up to date, without anyone running a manual job.

Publishing to Power BI Service

Publishing to Power BI Service

Why this matters

  • Always-on TM1 reporting — Dashboards in the Power BI Service stay synchronised with TM1, automatically.

  • No manual refresh cycles — Scheduled refresh removes the recurring task of opening Power BI Desktop and republishing every time numbers change.

  • One source of truth, accessible anywhere — Power BI Service dashboards open in any browser and in the Power BI mobile app, so users see the latest TM1 figures on whatever device they have.

  • Secure by default — Published dashboards still respect the TM1 security model — see 🔒 Securing Your Power BI Reports.