Tips for authoring template apps in Power BI
When you're authoring your template app in Power BI, part of it is the logistics of creating the workspace, testing it, and production. But the other important part is obviously authoring the report and the dashboard. We can break down the authoring process into four main components. Working on these components helps you create the best possible template app:
- With queries, you connect and transform the data, and define parameters.
- In the data model, you create relationships, measures, and Q&A improvements.
- Report pages include visuals and filters to provide insights into your data.
- Dashboards and tiles offer an overview of the insights included.
- Sample data makes your app discoverable immediately after installation.
You may be familiar with each piece as existing Power BI features. When building a template app, there are additional things to consider for each piece. See each section below for more details.
For template apps, queries developed in Power BI Desktop are used to connect to your data source and import data. These queries are required to return a consistent schema and are supported for Scheduled Data refresh (DirectQuery isn't supported).
Connect to your API
To get started, you need to connect to your API from Power BI Desktop to start building your queries.
You can use the Data Connectors that are available in Power BI Desktop to connect to your API. You can use the Web Data Connector (Get Data -> Web) to connect to your Rest API or the OData connector (Get Data -> OData feed) to connect to your OData feed.
Currently template apps do not support custom connectors, it is recommended to explore using Odatafeed Auth 2.0 as a mitigation for some of the connection use-cases or to submit your connector for certification. For details on how to develop a connector and certify it check the Data Connectors documentation.
Consider the source
The queries define the data that's included in the data model. Depending on the size of your system, these queries should also include filters to ensure your customers are dealing with a manageable size that fits your business scenario.
Power BI template apps can execute multiple queries in parallel and for multiple users concurrently. Plan ahead your throttling and concurrency strategy and ask us how to make your template app fault tolerant.
Ensure your queries are resilient to changes in your system, changes in schema on refresh can break the model. If the source could return null or missing schema result for some queries, consider returning an empty table or a meaningful custom error message.
Parameters in Power BI Desktop allow your users to provide input values that customize the data retrieved by the user. Think of the parameters up front to avoid rework after investing time to build detailed queries or reports.
Template apps support all parameters except Any and Binary.
Additional query tips
- Ensure all columns are typed appropriately.
- Columns have informative names (see Q&A).
- For shared logic, consider using functions or queries.
- Privacy levels are currently not supported in the service. If you get a prompt about privacy levels, you may need to rewrite the query to use relative paths.
A well-defined data model ensures your customers can easily and intuitively interact with the template app. Create the data model in Power BI Desktop.
You should do much of the basic modeling (typing, column names) in the queries.
The modeling also affects how well Q&A can provide results for your customers. Ensure you add synonyms to commonly used columns and you've properly named your columns in the queries.
Additional data model tips
Make sure you've:
- Applied formatting to all value columns. Apply types in the query.
- Applied formatting to all measures.
- Set default summarization. Especially "Do Not Summarize", when applicable (for unique values, for example).
- Set data category, when applicable.
- Set relationships, as necessary.
The report pages offer additional insight into the data included in your template app. Use the pages of the reports to answer the key business questions your template app is trying to address. Create the report using Power BI Desktop.
Additional report tips
- Use more than one visual per page for cross-filtering.
- Align the visuals carefully (no overlapping).
- Page is set to "4:3" or "16:9" mode for layout.
- All of the aggregations presented make numeric sense (averages, unique values).
- Slicing produces rational results.
- Logo is present on at least the top report.
- Elements are in the client's color scheme to the extent possible.
The dashboard is the main point of interaction with your template app for your customers. It should include an overview of the content included, especially the important metrics for your business scenario.
To create a dashboard for your template app, just upload your PBIX through Get Data > Files or publish directly from Power BI Desktop.
Additional dashboard tips
- Maintain the same theme when pinning so that the tiles on your dashboard are consistent.
- Pin a logo to the theme so consumers know where the pack is from.
- Suggested layout to work with most screen resolutions is 5-6 small tiles wide.
- All dashboard tiles should have appropriate titles/subtitles.
- Consider groupings in the dashboard for different scenarios, either vertically or horizontally.
Template apps, as part of the app creation stage, wraps the cache data in the workspace as part of the app:
- Allows the installer to understand the functionality and purpose of the app before connecting data.
- Creates an experience that drives the installer to further explore app capabilities, which leads to connecting the app dataset.
We recommend having quality sample data before creating the app. ensure the app report and dashboards are populated with data.
Publishing on AppSource
Template apps can be published on AppSource, follow these guidelines before submitting your app to AppSource:
- Make sure you create a template app with engaging sample data that can help the installer understand what the app can do (empty report & dashboard aren't approved). Template apps support sample data only apps, make sure to check the static app checkbox. Learn more
- In general, only application with valuable functionality can be approved for general use on AppSource. Application with sample data content only must have either a guidance or statistical value.
- Have instruction for the validation team to follow which includes credentials and parameters that are required to connect to data.
- Application must include an App icon in Power BI and on your CPP offer. Learn more
- Landing page configured. Learn more
- Make sure to follow the documentation on Power BI App offer.
- In case a dashboard is part of your app, make sure it's not empty.
- Install the app using the app link before submitting it, make sure you can connect the dataset and the app experience is as you planned.
- Before uploading bpix into the template app workspace, make sure to unload any unnecessary connections.
- Follow Power BI Best design practices for reports and visuals to achieve maximum impact on your users and getting approved for distribution.
|Contents: Datasets||Exactly one dataset should be present. Only datasets built in Power BI Desktop (.pbix files) are allowed.
Not supported: Datasets from other template apps, cross-workspace datasets, paginated reports (.rdl files), Excel workbooks
|Contents: Dashboards||Real-time tiles aren’t allowed (in other words, no support for push or streaming datasets)|
|Contents: Dataflows||Not supported: Dataflows|
|Contents from files||Only PBIX files are allowed.
Not supported: .rdl files (paginated reports), Excel workbooks
|Data sources||Data sources supported for cloud Scheduled Data refresh are allowed.
|Dataset: cross-workspace||No cross-workspace datasets are allowed|
|Query parameters||Not supported: Parameters of type "Any" or "Binary" type block refresh operation for dataset|
|Custom visuals||Only publicly available custom visuals are supported. Organizational custom visuals not supported|