mlongoria

M0 -0.97Q 0.62 -0.76 0 0.08Q 0.62 -0.76 1 -0.24Q 0.67 0.3 0 0.08Q 0.67 0.3 0.62 0.93Q 0 0.79 0 0.08Q 0 0.79 -0.62 0.93Q -1 0.3 0 0.08Q -1 0.3 -1 -0.24Q -0.62 -0.76 0 0.08Q -0.62 -0.76 0 -0.97Q 0.62 -0.76 0 0.08z

mlongoria

{
    "data": {"name": "dataset"},
    "title": "Change In Percent of Americans Living Alone - 1980 vs 2018",
    "height": 40,
    "width": 350,
    "mark": {"type": "trail"}, 
  "encoding": {
    "facet": {
      "field": "Entity",
      "title": null,

mlongoria

{
  "data": {"name": "dataset"},
 "mark": "area",  
  "encoding": {
    "x": {
      "timeUnit": "weekyear",
      "field": "Date",
      "title": null,
      "axis": {"domain": false, "format": "%b %Y", "tickSize": 0}
    },

mlongoria

let
    //Get values 0 - 255
    Source = Values,
    //Call that column R for Red
    #"R Dec" = Table.RenameColumns(Source,{{"Column1", "R Dec"}}),
    //Crossjoin to Values to get Green values 0 - 255
    #"G Dec" = Table.AddColumn(#"R Dec", "Custom", each Values),
    #"Expanded G Dec" = Table.ExpandTableColumn(#"G Dec", "Custom", {"Column1"}, {"G Dec"}),
    //Crossjoin to Values to get Blue values 0 - 255
    #"B Dec" = Table.AddColumn(#"Expanded G Dec", "B", each Values),

mlongoria

CREATE PROC SwapWithMetadata
    @SrcSchema NVARCHAR(128),
    @SrcTable NVARCHAR(128),
    @DestSchema NVARCHAR(128),
    @DestTable NVARCHAR(128),
    @TransferMetadata BIT,
    @DropOldTable BIT
AS

BEGIN

mlongoria

<!-- This goes in your data flow as the source -->
<CustomComponent Name="TF Dynamics 365 <#=table.Name#>" ComponentTypeName="PragmaticWorks.TaskFactory.DynamicsSource" Version="1" ContactInfo="Dynamics Source;Pragmatic Works, Inc; Task Factory (c) 2009 - 2016 Pragmatic Works, Inc; http://www.pragmaticworks.com;support@pragmaticworks.com" UsesDispositions="true">
                <Annotations>
                    <Annotation AnnotationType="Description">Extract data from Microsoft Dynamics CRM.</Annotation>
                </Annotations>
                <DataflowOverrides>
                     <OutputPath OutputPathName="Dynamics Source Output">
                     <!-- Iterate through the columns (I'm passing in table and column from another file), ignoring any audit columns you may have added to your table. Set the Error Row Disposition and Truncation Row Disposition. -->
                           <# foreach (var column in table.Columns.Where(c => !c.Name.Equals("AuditETLLogID") &&  !c.Name.Equals("AuditIn

mlongoria

<#@ import namespace="System.Data" #>
<#@ import namespace="System.Text" #>
<#@ property name="targetTables" type="DataView"#>
<#@ property name="frequency" type="string"#>
<#@ property name="scope" type="string"#>
{
    "$schema": "http://datafactories.schema.management.azure.com/schemas/2015-09-01/Microsoft.DataFactory.Pipeline.json",
    "name": "PL_Copy_MySourceDBToADLS_<#=frequency#>_<#=scope#>",
  "properties": {
    "description": "<#=frequency#> <#=scope#> copies of data from Source db to the data lake.",

mlongoria

<#@ template tier="10" #>
<#@ import namespace="System.Data" #>
<#@ import namespace="System.Text" #>
<#@ code file="BGHelper.cs" #>
<#@ import namespace="BGHelper" #>

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
</Biml>
<#
    string mdFilePath = "C:\\Users\\admin\\Source\\Workspaces\\SH Data Warehouse\\metadata";

mlongoria

<#@ property name="schema" type="string" #>
<#@ property name="table" type="string" #>
<#@ property name="frequency" type = "string" #>

{
    "$schema": "http://datafactories.schema.management.azure.com/schemas/2015-09-01/Microsoft.DataFactory.Table.json",
    "name": "DS_OnPremSQL_MySourceDB_<#=schema#>_<#=table#>",
    "properties": {
        "type": "SqlServerTable",
        "linkedServiceName": "LS_OnPremSQL_MySourceDB",

mlongoria

//list available DMVs
Select * from $SYSTEM.DBSCHEMA_TABLES where table_type = 'Schema' order by table_name

//Useful DMVs for 2016 SSAS Tabular Models
Select * from $SYSTEM.TMSCHEMA_ATTRIBUTE_HIERARCHY_STORAGES //distinct data count for each column
Select * from $SYSTEM.TMSCHEMA_ATTRIBUTE_HIERARCHIES  //ties hierarchy id to column
SELECT * from $SYSTEM.TMSCHEMA_COLUMN_STORAGES //has order by column, row count is inaccurate
Select * from $SYSTEM.TMSCHEMA_COLUMNS //column name, ID for table, data type, category, hidden, iskey, isunique, is nullable, summarize by, expression for calc columns, hierarchy id, refresh time, modify time. source provider type, display folder
SELECT * from $SYSTEM.TMSCHEMA_DATA_SOURCES //connection string, account, impersonation mode, name
Select * from $SYSTEM.TMSCHEMA_HIERARCHIES //hierarchy name, display folder