Enterprise tabular models are often built using Visual Studio plus its Analysis Services projects add-on. Publishing such a project into Power BI needs add-on version 2.9.14+, compatibility 1500+, and XMLA read-write switched on.
Also called SQL Server Data Tools.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains SSDT in context, with comparison tables and the common traps.
Terms in this definition
- Enterprise
Any group of organisations with shared goals. Examples range from an entire company or one of its divisions to a government department, or several organisations working as partners or along a supply chain.
- Analysis Services
VertiPaq, Microsoft's in-memory analytics engine, sits underneath every Power BI semantic model and is likewise available as Azure Analysis Services or SQL Server Analysis Services. Tools connect to it over XMLA, using its client libraries.
- Foundry project
A container beneath a Foundry resource that keeps one team's agents, data, files, evaluations and project connections separate. Model deployments and resource-level connections are shared from the parent, and governance is not configured at this level.
- Power BI
Microsoft's analytics and reporting service. It reaches data held on-premises through the on-premises data gateway.
Related terms
- SQL Server unit tests
Visual Studio SSDT tests that execute T-SQL against a test database, with test conditions deciding whether each outcome passes.