A learning resource for Tabular Editor and more. The Tabular Editor Enterprise Trainings have been recently released as a free community learning resource. These trainings provide an interactive learning experience to learn about Tabular Editor and data modeling for AAS, SSAS, and Power BI datasets. As part of these trainings, you get access to over […]
The Spaceparts Co. Dataset Read More »
A full tutorial on how to use Tabular Editor 3 to create Fabric Direct Lake datasets directly in the tool.
Fabric Direct Lake with Tabular Editor – Part 2: Creation Read More »
It is August and its time for a new version of Tabular Editor 3. Summer is heading into its waning days and even though the plan was to make minor improvements and fix bugs in this release, we couldn’t help ourselves and had to get a new feature in: Support for Direct Lake datasets. If
Tabular Editor 3 August 2023 Release Read More »
Direct Lake Datasets: How to use them with Tabular Editor In Microsoft Fabric, datasets have the capability to use Direct Lake mode to connect directly to data sources stored in OneLake as delta tables, which you can create with the various analytical workloads of Fabric. Datasets using Direct Lake (referred to as Direct Lake datasets)
Fabric Direct Lake Dataset Read More »
Benefits and use-cases Power BI provides a variety of ways to enable users with self-service analytics. For example, organizations can opt for a managed self-service BI model (instead of a centralized enterprise BI model). In this model, a Center of Excellence (COE) or central team of data professionals create and manage Power BI datasets. Business
Composite models in Power BI and Fabric Read More »
A Sewing Machine for Fabric Microsoft Fabric is an all-in-one analytics platform announced earlier this year that unifies Data Factory, Synapse and Power BI under one roof. With Tabular Editor, you can develop and manage Power BI datasets that are deployed to workspaces using Fabric dedicated capacity. The new capabilities of Fabric and the features
Using Tabular Editor in Microsoft Fabric Read More »
Multilingual Datasets A little known fact about the Power BI service, is that metadata translations actually work just fine for an imported or DirectQuery dataset within a dedicated capacity workspace (Power BI Premium or A SKUs). You can add metadata translations to a dataset in Premium in two ways: Either through the XMLA read/write endpoint or by
Creating Multilingual Power BI Datasets Read More »
This article provides a step-by-step instruction on how to enable Service Principal (SP) access to a Power BI workspace in dedicated capacity (Power BI Premium or embedded/A sku). In the following, I will try to highlight the minimal number of steps necessary to enable Service Principal authentication. You can find all the details in the
Service Principal access to dedicated capacity XMLA endpoint Read More »
Update May 29th 2019: It turns out that the technique outlined here can be used for SSAS or Azure Analysis Services Tabular models of Compatibility Level 1400+. In fact, just by adding the ParameterMetadata Extended Property (step 9 below) to any numeric column in your model, you can instruct Power BI to display a single-select slider as
Power BI Tricks – WhatIf parameters Read More »
