Table of Contents

Environments

Environments are how you separate your connections from your model. Instead of hard-coding a database server into your model, you set up environments like "Development," "Staging," and "Production," each pointing to different servers and databases.

Click the Environments icon in the activity bar to manage them.

What's in an Environment

Each environment stores:

  • A Working Server: where Semantic Modeler deploys your model temporarily for data preview and DAX queries
  • A Publish Server: where your finished model gets deployed for report consumption
  • Data Source Connections: the database connections for that environment

This means you can develop against a dev database, test against staging, and publish to production, all from the same model without having to manually change connection credentials for each publish.

Switching Environments

Select a different environment from the dropdown. The model immediately uses the new connections. Your tables, measures, and relationships stay exactly the same; only the underlying servers and databases change.

For a deeper look at environments and how to set them up, see Environments in the Features section.