Overview

When connecting Power BI to any data model, it's necessary to clean up pieces of the data, rename fields (if desired), create keys, and assign relationships. The Cosmos data model templates that can be downloaded from this article already have this work done for you so you can simply connect it to your Cosmos data and start building dashboards.

Details

Attached to this article are data model templates for the following areas of Cosmos:

• Accounts Payable
• Accounts Receivable
• General Ledger
• Inventory
• Purchasing
• Sales

You can download these templates and use them to hook up to your Cosmos data to quickly begin building all your own Power BI dashboards. These templates have all the keys added to the data tables as well as Power BI relationships pre-defined. 

You can click the Download button on the links below to download each of the templates which are saved as PBIT files (Power BI Templates). 

These are region-specific, so make sure to download the correct version:

• CA: Canadian customers
• EU: European Union customers
• UK: United Kingdom customers
• US: United States customers

For more information on how to use these templates to hook up to your Cosmos data you can read the article below:

How to Connect the Pre-Built Power BI Templates and Dashboards to your Cosmos Data