Steps for developing Power BI content

Getting Started with Power BI Development

To get started developing in Power BI you will need the following:

An excellent resource for getting started is to visit Power BI Documentation provided by Microsoft.

Planning Development Environment

When trying to plan out your development environment, you want to map your development lifecycle to how Power BI content is organized within the Power BI Service. The Power BI Service is structured around workspaces, each consisting of their own unique permissions/security. The following are some planning guidelines.

Planning Steps

  • Security: Determine which users/groups will need access to your Power BI workspaces. For more information, go to Organize work in the new workspaces in Power BI
  • Workspaces: Create the necessary workspaces to match your development lifecycle. For information about creating workspaces, go to Create a new workspace.
  • Application Lifecycle Management: If you maintain development, test, and production environments for your development workflow, you will want to plan your Power BI workspaces accordingly. A best practice is to create workspaces for each environment in your development workflow. Power BI provides a solution to facilitate your application lifecycle management called Power BI Deployment Pipelines. For more information on how to get started, go to getting started with deployment pipelines.

Building Your Development Environment

  • Create Workspaces: Create the necessary workspaces to match your development lifecycle. For example, create workspaces for development, test, and production where needed. For information about creating workspaces, go to Create a new workspace. With the introduction of Power BI Deployment Pipelines, you can streamline the workspace creation process by utilizing Deployment Pipelines to build your development, test, or production workspaces for you. For example, you can start by creating a production workspace and then create a new Deployment Pipeline that facilitates the creation of your development and test workspaces. For more information, go to Create a deployment pipeline
  • Security: Manage access to your workspaces. For more information, go to Give access to your workspace. For an explanation of the different roles, you can grant to workspace access, go to Roles in workspaces.

Developing Power BI Content

Development guidelines change frequently as Microsoft updates Power BI functionality. It is a good habit to check this page for development best practices.  In this documentation, and Microsoft's, "the service" refers to the Power BI Cloud service rendered in your browser. "Power BI Desktop" refers to the authoring desktop tool installed on your local machine.  "Power BI" refers to the entire Microsoft Power BI Product line.

  1. Create a report using Power BI desktop. Reports can be edited in the service but it is best practice to edit in the desktop tool. 
  2. Publish the reports to a workspace.  By default, all users can publish to My workspace for initial development. For more information about publishing to the Power BI Service, go to Publish datasets and reports from Power BI Desktop.
  3. Separate the dataset from the report. By default Power BI Desktop creates two pbix files when publishing to the service, a dataset and a report.  Both have the same name.  It is best practice to rename the data set file adding the prefix "dataset_".  Then download the report file and connect to the dataset_ pbix file on the service. Republish the report. 
  4. Power BI Data Flows are the best choice for getting data for a report. They provide standardized configuration and data manage refresh and security to on-premise UCSB data.  For more information about dataflows, go to Getting Started with Dataflows. On the Get Data function in Power BI Desktop, select Power BI Platform and the Power BI data flows to create tables using data flows.  You can also connect directly to complete datasets by selecting Power BI Platform > Power BI data sets on the Get Data function in Power BI desktop.
  5. Testing and moving data to production requires multiple workspaces  Typically development and test are available to a limited set of users. Best practice is to begin the workspace name with the prefix "ws_".  Development and test workspaces should be suffix by [Developement] and [Test] respectively.  Production workspaces do not have a suffix. Use Power BI Deployment Pipelines to move data through the workspaces.
    1. For more information regarding workspace naming conventions best practices for UCSB, go to Power BI Naming Conventions.

Developer Resources

Power BI Documentation: https://docs.microsoft.com/en-us/power-bi/

Power BI Developer Center: https://powerbi.microsoft.com/en-us/developers/

Power BI Learning: https://powerbi.microsoft.com/en-us/learning/

On-Premise Data Gateways: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

Power BI REST APIs: https://docs.microsoft.com/en-us/rest/api/power-bi/

Power BI Embedded: https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedding

Power BI Blog - Updates & News: https://powerbi.microsoft.com/en-us/blog/