Data Analytics
  • All of Microsoft
  • Python
  • My Role
    • All in My Role
    • Data Analytics
  • Focus
    • All in Focus
    • Microsoft Fabric
    • What's Hot
    • M365 Release
  • Security & Identity
Timespan
explore our new search
Power BI Fabric Web Apps for custom BI experiences
Power BI

Power BI Fabric Web Apps for custom BI experiences

by HubSite 365 about Reza Rad (RADACAD) [MVP]

Founder | CEO @ RADACAD | Coach | Power BI Consultant | Author | Speaker | Regional Director | MVP

Fabric Web Apps let developers build custom web experiences that query Power BI semantic models and display tailored visualizations.

Key insights

  • Fabric Web Apps can query a Power BI semantic model directly.
  • The approach uses HTML and JavaScript rather than generating a traditional PBIR report first.
  • The web app can create Vega-Lite visualizations from semantic-model data.
  • An app can use separate semantic models on different pages without creating a proxy model.
  • The app scaffolding handles authentication and semantic-model queries, and can generate DAX.

Power BI Fabric Web Apps let developers create custom web applications that query semantic models and present data in tailored visualizations. This approach is for developers and BI teams looking to build interactive experiences beyond a conventional report canvas. Reza Rad (RADACAD) [MVP] demonstrates the approach and describes how the apps can work with semantic models.

What's new

Traditional Power BI reports use PBIR, a JSON-based format that calls Power BI services to render report experiences. Fabric Web Apps offer another route: build a web application with HTML and JavaScript, and connect it to a semantic model. The app can present reporting as part of a custom interface rather than as a standard report.

The key distinction is that this approach queries the semantic model directly. An app can use existing model definitions and generate DAX for queries, instead of requiring a separate proxy model. The app can also use Vega-Lite visualizations, a format for describing data charts, as part of its web experience.

Who it is for and what you need

This approach is aimed at developers who want to build a custom reporting experience, including teams using AI tools to generate HTML and JavaScript. The starting point is a semantic model containing the data the application needs to query. The model supplies a connection to the data; the web app supplies the interface and visualization experience.

Fabric Apps are described as being in preview. That makes it sensible to evaluate the approach in the context of development and testing rather than assume it is a replacement for established Power BI report delivery.

How it works

  1. Choose the semantic model or models that the application will use.
  2. Describe the report or application you want, such as a sales-data report, and use the app-building skills to generate the web experience.
  3. Use the generated scaffolding for authentication and model connectivity. The application can query a model and generate DAX for the data it needs.
  4. Add visualizations, including Vega-Lite visuals, and organize the experience around the intended task.
  5. For multiple models, assign them to different pages. Each page can query its own model directly rather than using a proxy model.

The scaffolding is intended to take care of parts of web development that developers would otherwise have to assemble, including authentication and semantic-model queries. That lets the builder focus more on the application experience and the questions it should answer.

Limitations and alternatives

A Fabric Web App is a different development route, not simply a Power BI report with a new name. It involves building a web application, so teams should decide whether they need a custom interface before choosing it over a traditional report. The preview status also makes testing and evaluation important before relying on it for a production workflow.

Check that the semantic model or models contain the data the app needs, and that the generated queries and visualizations meet the intended requirements. If the goal is conventional report authoring, PBIR and the Power BI report experience remain the alternative described here.

Sources

Frequently asked questions

What are Power BI Fabric Web Apps?

They are custom web applications that can query Power BI semantic models and present data in a tailored interface with visualizations.

Can a Fabric Web App use more than one semantic model?

Yes. Different pages can query different semantic models directly, without creating a proxy model.

Do Fabric Web Apps generate DAX?

The app scaffolding can generate DAX for queries against a semantic model.