GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → m-kovalsky → MiniModelBuilder

m-kovalsky / MiniModelBuilder

Licence: MIT License
A tool for customizing and dynamically generating a tabular model from an existing tabular model.

Programming Languages

C#
18002 projects

Labels

daxpowerbitabularanalysisservicesssas-tabulartabulareditor

Projects that are alternatives of or similar to MiniModelBuilder

Tabular
Useful code for tabular modeling and automation.
Stars: ✭ 73 (+421.43%)
Mutual labels:  powerbi, tabular, analysisservices, ssas-tabular, tabulareditor
ModelAutoBuild
A framework for dynamically creating a tabular model based on an Excel template.
Stars: ✭ 43 (+207.14%)
Mutual labels:  dax, powerbi, tabular, tabulareditor
TabularEditor
This is the code repository and issue tracker for Tabular Editor 2.X (free, open-source version).
Stars: ✭ 632 (+4414.29%)
Mutual labels:  powerbi, ssas-tabular
PowerBI-book-ru
Проект открытого методического пособия по Power BI, Power Query, Power Pivot
Stars: ✭ 76 (+442.86%)
Mutual labels:  dax, powerbi
PowerBI
This repository hosts well-written DAX formulas and tested Power BI PBIX samples with data sources.
Stars: ✭ 38 (+171.43%)
Mutual labels:  dax, powerbi
powerbi-visuals-chartxkcd
Power BI custom visual, providing an interface to chart.xkcd
Stars: ✭ 37 (+164.29%)
Mutual labels:  powerbi
Power-BI-Automation
Automate tasks in Power BI based on the Power BI Powershell cmdlets and the Power BI REST API
Stars: ✭ 44 (+214.29%)
Mutual labels:  powerbi
terraform-modules
Terraform Modules by Peak
Stars: ✭ 16 (+14.29%)
Mutual labels:  dax
WooCommerceConnector
A Power BI Custom Connector for WooCommerce
Stars: ✭ 27 (+92.86%)
Mutual labels:  powerbi
PowerBI-visuals-AttributeSlicer
Attribute Slicer custom visual for PowerBI
Stars: ✭ 24 (+71.43%)
Mutual labels:  powerbi
SSIS-DB-Dashboard
PowerBI SSIS Catalog DB Dashboard
Stars: ✭ 55 (+292.86%)
Mutual labels:  powerbi
poweRbi
An R-based, httr-style interface for the Power BI REST API.
Stars: ✭ 17 (+21.43%)
Mutual labels:  powerbi
m-custom-functions
This library contains created mostly pure M-functions without any other languages.
Stars: ✭ 24 (+71.43%)
Mutual labels:  powerbi
PBIConnectors
The Microsoft Power BI custom connector support-project
Stars: ✭ 60 (+328.57%)
Mutual labels:  powerbi
crm-powerbi-viewer
Embed tiles and reports from Power BI into Dynamics CRM Forms and Dashboards.
Stars: ✭ 24 (+71.43%)
Mutual labels:  powerbi
lodata
The OData v4.01 Producer for Laravel
Stars: ✭ 40 (+185.71%)
Mutual labels:  powerbi
PowerQueryNet
Run M Language (Power Query Formula Language) from anywhere.
Stars: ✭ 146 (+942.86%)
Mutual labels:  powerbi
powerbi
Repository with links and files for using in PowerQuery and PowerBI
Stars: ✭ 32 (+128.57%)
Mutual labels:  powerbi
awesome-power-platform
A collection of awesome things regarding the Power Platform ecosystem.
Stars: ✭ 36 (+157.14%)
Mutual labels:  powerbi
awesome-csv
Awesome Comma-Separated Values (CSV) - What's Next? - Frequently Asked Questions (F.A.Q.s) - Libraries & Tools
Stars: ✭ 46 (+228.57%)
Mutual labels:  tabular
View All Similar Projects ➔

Mini Model Builder

Mini Model Builder is a tool that allows you to customize a 'mini model' based on an existing tabular model. This tool runs inside of Tabular Editor's Advanced Scripting feature. This tool is compatible for all destinations of tabular models - SQL Server Analysis Services, Azure Analysis Services, and Power BI Premium (using the XMLA endpoint). This tool is also viable for both in-memory and direct query models.

Mini Model Builder

Purpose

Call them what you want - 'micro cubes', 'mini models', 'derivative models' - this tool is designed to simplify the process of creating a 'mini model'. It is also designed with the intention of being used by a broader audience than just the tabular developer community.

Running the Tool

1.) Download the following file to your computer.

  MiniModelBuilder.cs

2.) Open Tabular Editor.

3.) Connect to your model.

4.) Paste the MiniModelBuilder.cs script inside the Advanced Scripting window within Tabular Editor.

5.) Click the 'Play' button (or press F5).

Creating the 'Mini Model'

After you set up a mini model using the Mini Model Builder tool and deploy your model to a server, you can generate the mini model.

1.) Download the following file to your computer.

   MiniModelBuilder_Create.cs

2.) Run the following code in the command prompt below (filling in the <parameters>) according to the variety of tabular you are using.

Since each of the scripts below uses an Environment Variable (set miniModelName=), there is no need to duplicate the MiniModelBuilder_Create.cs file for each mini model. The same MiniModelBuilder_Create.cs file can be referenced for creating all mini models. Setting the 'miniModelName' Environment Variable instructs the code which mini model to create.

SQL Server Analysis Services

set miniModelName=<Mini Model Name>
start /wait /d "C:\Program Files (x86)\Tabular Editor" TabularEditor.exe "<Server Name>" "<Database Name>" -S "<C# Script File Location (MiniModelBuilder_Create.cs)>"

Azure Analysis Services

set miniModelName=<Mini Model Name>
start /wait /d "C:\Program Files (x86)\Tabular Editor" TabularEditor.exe "Provider=MSOLAP;Data Source=asazure://<AAS Region>.asazure.windows.net/<AAS Server Name>;User ID=<xxxxx>;Password=<xxxxx>;Persist Security Info=True;Impersonation Level=Impersonate" "<Database Name>" -S "<C# Script File Location (MiniModelBuilder_Create.cs)>"

Power BI Premium

Running this in Power BI Premium requires enabling XMLA R/W endpoints for your Premium Workspace. An additional requirement is setting up a Service Principal.

set miniModelName=<Mini Model Name>
start /wait /d "C:\Program Files (x86)\Tabular Editor" TabularEditor.exe "Provider=MSOLAP;Data Source=powerbi://api.powerbi.com/v1.0/myorg/<Premium Workspace>;User ID=app:<Application ID>@<Tenant ID>;Password=<Application Secret>" "<Premium Dataset>" -S "<C# Script File Location (MiniModelBuilder_Create.cs)>"

Instructions for using the program

  • For navigation, either use the 'Next' button or click directly on a particular step using the Navigation pane.
  • Only Step 1 is necessary. All other steps are optional.
  • Always click the 'Save' button after making a change. If the 'Save' button is not pressed, your changes will not be saved.

Features

  • Step 1: Select which objects you need in your mini model. Object dependencies are automatically added to your mini model.
  • Step 2: Simply toggle to hide or unhide objects (tables, measures, columns, hierarchies) within your mini model. If an object shows as gray in this step it will be hidden in the mini model. If an object shows in black, it will be visible in the mini model.
  • Step 3: Update the DAX for measures or calculated columns in your mini model.
  • Step 4: Remove non-necessary partitions from multi-partitioned tables in your mini model.
  • Step 5: Remove non-necessary perspectives.
  • Step 6: Perform a find-and-replace within your partition queries. This allows you to easily repoint your tables/partitions to a different schema in your data warehouse.
  • Step 7: Update role members and model permission for your mini model.
  • Step 8: Update the row level security (RLS) for any role and table that has RLS filters within the original model.
  • Step 9: Update tables to point to a different data source (choosing among the data sources within the original model).
  • Step 10: Filter your model based on column values. The column filters should be placed on dimension tables. These filters will be applied to the related fact tables as well (based on existing relationships).
  • Step 11: Set aggregations to minimize row counts in your mini model. Use the light bulb icon to recommend summarizations for each of the columns in your table. Aggregations are only for tables on the 'from-side' of a relationship (in other words, Fact tables).
  • Summary: Shows a full summary of all the differences between the original model and the mini model.
  • Blue icon indicates an object is different in the mini model as compared to the original model.
  • Automatically updates perspectives and annotations to ensure your mini model is created exactly as specified.
  • All relationships and model integrity is passed on from the original model to the mini model.
  • In the Summary view, the 'Script' button will output a C# file to your desktop which contains all the instructions for creating your mini model. This can be executed in the 'Advanced Scripting' window against the original model.

Requirements

  • Tabular Editor version 2.12.1 or higher.
  • Compatible for SQL Server Analysis Services, Azure Analysis Services, and Power BI Premium models.
  • Compatible for tabular models using Import-mode, Direct Query mode, and Composite models.
  • Make sure to click the 'Save' button within each page of the Mini Model Builder after making changes.
  • To use the 'Filter Column Values' step, you must be live-connected to an Analysis Services model.
  • To use either the 'Filter Column Values' or 'Set Aggregations' steps, your data source must be a SQL-type source and partition queries must start with 'SELECT * FROM ...'.

Version History

  • 2021-04-23 Version 1.0.2 released
  • 2021-03-08 Version 1.0.1 released
    • MiniModelBuilder_Create.cs now uses an Environment Variable so the script is completely reusable for all mini models.
  • 2020-12-01 Version 1.0.0 released on GitHub.com
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].