Skip to main content

Power BI Example

For API-driven reporting, Microsoft Power BI provides:

  • Interactive Dashboards: Rich visualizations and interactive reports

  • Real-time Updates: Automatic data refresh capabilities (Pro/Premium tiers)

  • Scalability: Handles large datasets more efficiently

  • Collaboration: Cloud-based sharing and collaboration features

  • Advanced Analytics: Built-in AI and advanced analytical capabilities

  • Mobile Access: Reports accessible on mobile devices

This example uses the sample file PowerBI-REST-Example.pbit. Contact support for assistance.

Procedure

  1. Open the PowerBI-REST-Example.pbit template.

  2. Provide instance information when prompted.

    • BaseUrl - format <protocol>:/<fabric-hostname>/<instance>

    • Username - REST API user account

    • Password- REST API user password

    • ExcelFilePath - full Excel file path

    • UseExcelFile (true for sample data, false for live API)

  3. Click Load.

In this section: