Thursday, July 23, 2020

Power Query - Using Combine of Dataflows




let
    Source = PowerBI.Dataflows(null),
    Source01 = PowerBI.Dataflows(null),
    Source02 = PowerBI.Dataflows(null),
    Source03 = PowerBI.Dataflows(null),

    Step00 = Source{[workspaceId="workspaceIdXPTO"]}[Data], //Vendas_PRD
    StepT0 = Step00{[dataflowId="dataflowIdXPTOA"]}[Data], //Diario
    StepT0a = StepT0{[entity="FAT_SAP_Vendas_Diario"]}[Data],

    Step01 = Source01{[workspaceId="workspaceIdXPTO"]}[Data], //Vendas_PRD
    StepT1 = Step01{[dataflowId=DF2018]}[Data], //dataflowIdXPTOB
    StepT1a = StepT1{[entity="FAT_SAP_Vendas_2018"]}[Data],

    Step02 = Source02{[workspaceId="workspaceIdXPTO"]}[Data], //Vendas_PRD
    StepT2 = Step02{[dataflowId=DF2019]}[Data], //dataflowIdXPTOC
    StepT2a = StepT2{[entity="FAT_SAP_Vendas_2019"]}[Data],

    Step03 = Source03{[workspaceId="workspaceIdXPTO"]}[Data], //Vendas_PRD
    StepT3 = Step01{[dataflowId=DF2020]}[Data], //dataflowIdXPTOD
    StepT3a = StepT3{[entity="FAT_SAP_Vendas_2020"]}[Data],

    StepJoin = Table.Combine({StepT0a , StepT1a, StepT2a, StepT3a})
in
    StepJoin

Wednesday, July 22, 2020

Using external tools in Power BI Desktop (Json Files)







Abaixo a descrição de cada elemento no arquivo JSON:
  • name: Forneça um nome para a ferramenta, que aparecerá como uma legenda do botão na
  • description: (opcional) Forneça uma descrição, que aparecerá como uma dica de ferramenta no botão da faixa de opções Ferramentas externas no Power BI Desktop.
  • path: Forneça o caminho completo para o executável da ferramenta.
  • arguments: (opcional) Forneça uma sequência de argumentos da linha de comando com a qual o executável da ferramenta deve ser iniciado. Você pode usar qualquer um dos seguintes espaços reservados:
    %server%: Substituir pelo nome do servidor e pelo número da porta da instância local dos modelos de dados de importação/DirectQuery do formulário do Analysis Services Tabular.
    %database%: Substitua pelo nome do banco de dados do modelo hospedado na instância local do Analysis Services Tabular para modelos de dados importados / DirectQuery.
  • iconData: Forneça dados de imagem, que serão renderizados como um ícone de botão na faixa de opções Ferramentas externas no Power BI Desktop.
A cadeia de caracteres deve ser formatada de acordo com a sintaxe dos URIs de dados sem o prefixo “data:”.
É possível converter as imagens em formato base64 usando o seguinte site: https://www.base64-image.de/
Criar um arquivo texto
“<nome da ferramenta>.pbitool.json” e coloque-o na seguinte pasta:
Para máquinas 32 bits:
%commonprogramfiles%\Microsoft Shared\Power BI Desktop\External Tools
Para máquinas 64 bits:
c:\Program Files (x86)\Common Files\Microsoft Shared\Power BI Desktop\External Tools
Os arquivos nesse local especificado com a extensão .pbitool.json são carregados pelo Power BI Desktop na inicialização.


Segue (copy/paste) o codigo de cada ficheiro(Json):





01_calc.pbitool.json

{ "name": "Calc", "description": "", "path": "C:\\Windows\\System32\\calc.exe", "arguments": "", "iconData": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAMAAACdt4HsAAAAA3NCSVQICAjb4U/gAAAACXBIWXMAAAG7AAABuwE67OPiAAAAGXRFWHRTb2Z0d2FyZQB3d3cuaW5rc2NhcGUub3Jnm+48GgAAAY9QTFRF////AAAAAAAAYGBwSlJaXGlvR1FZXGdxXWdxXWZvXGdwQ05YXWZwQ01YUVxlXGZwXGdwQEpUP0pUPklTO0ZQXGZxPEZQNUBKAILKAYHHAYLKA4PLBHy/BITLBXy+BYTLB3m5FIzOFWeVF2SQGI7PHVyBIJLRKUtgKZbTK0hcK0lcL0NRMJrUMkBLMz5IND9JNUBKNkFLNpzVN0FLOUROO0VPPEZQPEdRPUhSPkhSPklTP0lTQEtVQUtVQUxWQk1XQqLYQ05YR1FbSVNdSlVfS1VfS1ZgTFZgTFdhTVdhTVhiTlljT1ljT1pkUFpkUFtlUKnbUVtlU11nVF5oVWBqVmBqVmFrV2FrV2JsWGJsWWNtWmRuWq7dW2VvXGZwYGdsZGlpZWlnZWloZbTfc25bdG9ZdLvidm9Xd7zjeL3jgXNOhHRKhMPliMXmiXZGi8bnjMfnjXdCjnhBkMnonM7qoNDrrNburdfutYUduocZvogVwYkSw+Lzz44Ez44F1JAA1+v39vv99/v9/P7+////LshLmQAAABh0Uk5TAAECEB8nSGFmjJCdnaOkucLLz9ns7vD+IqFBbgAAAitJREFUWMPtl1lb00AYhYd937cPRUUREZCUiiIKBRFapYtIQUpSc9x3RXHfcckP9yIznWmeBNO5EcT3qifNeS/mm8zzDGOMMVbe1NljlERPZ1M5K1DZbWjQXVkQdBhadIh+taFJNRc06AoauKBNPBgaOBaCgSHxfhsXtPM81keh6BvjhXaPYDiwcuLdaaJHL4hOvj9FRMMBgpFAwQPnDdEv5yg9c14S0UjJgsfOWyLHOU7Pndf7VXDxx12iL98P0bWfN3YQjPYGGo4Q0YGD/EfvaIDAGOw/HIL+QSNIUCr/BVLQnNakmQvqoUn9rhPkrnNMN2+IvOFmU+Scr8CelMs7BwDTMk8DwJzMk7aPIK0OaB3IqjkLrKs57SNIeAppT6FImNgTgoyaMyEEa8r/URswIzJHTMCOKi+s+e2D1MwFzmwWAFZiIsdWACA7K/JMardu5b8uiJ87yzmfAYDklMhTSQB48uET5+MrP8GqMqVxC8ipc88Bt75tS+5r7MSHSn97698UXPUsmrqoxmoIAWJyCJcAYL7wNUXmEUaAvMVxTzzYRTmEYGf2gsBcXOBczgOAFRc5boURWMoRdgbFR1jUDiG44pn7spqX98e3sPSHNbinCjb9pjDumcKEzBM2gM+y//VOkaDO3QfWUoKTsgEgnxQ5mQeAm0+3OJu33UYdF9Tonso1XFClK6gSV9dGvX5j4e5c0arTb62Q1/ey2pau0tpdLbVljDHGfgNujNPN09AeKQAAAABJRU5ErkJggg==" }

02_PowerBI_Helper.pbitool.json

{ "name": "PowerBI Helper", "description": "", "path": "C:\\Program Files (x86)\\RADACAD\\Power BI Helper\\Power BI Helper Application.exe" , "arguments": "", "iconData": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPQAAADPCAMAAAD1TAyiAAABX1BMVEX////tvREAAABJSUr/xD36rhfsugDuwznsuQD8/PxMTE345Kf02YP99uD5+fnuwB7s7Ozz8/P89Njy0XXwxjX9+ej/yz/23qLi4uL56LTnuRHz1G7o6OjR0dHc3NzdsBAeHh4/Pz/GxsYvLy83Nzj/0UGurq7BwcGPcgrLow//uBgLCwvAmQ4mJiZgSheKior+wDampqb+/PPEmC8VFRVnZ2dxcXGYmJjYrBBaWlq5ubl5eXmngCiNjY2CZB/OpDOYdyWnhQw/MA+jggwoHgnntzlYQhUYEQX67MFENRBTQgZ8WAuMYw3xzVu0kA3EnA4sIwN/ZQnwyUmzjiyGaSF0WhzuvDvZrDblxm+OfEolIhmolF3IrWX778thTADooxXTlxSodxBvWAhlRgncwXXlz5aomG/UwI3AhxIkGQT23pbpphZKNQd2bU+7s5rQybTRs1NGPySjmn8zLhq+spAJ611JAAAXp0lEQVR4nO2d+V8buZLAMSaNba42h8cYfF8xxjjm8kEIR8KVtxyBBGbfW2bysm/eTpjZndnj//+spJbUOrvbxoZ2Pqmfkqbd1tdVkkqlKvXIyIAlHI1uj6oku2xGp8OD/vrnkXA0HlRCV1PL3yz0dDSXUUKPluNm9NuADiNh/j9tdizGwzUiZ9aFJlS1/pPDI+HwNBC77eD/Zt1i3CjGLCneWRe2U3EGmnxy+LDD06jpNnY4HDXbFuPRGBXrQjAZNwl0GH+O/cGGQ0DDo81Cvh6PRqO48eHpaDyPEM9ilLl4aFHnUqY1kgHk6LTZLNR2zeiQDW6g5ZZWqyU4G8HGw0vlKiL8xEC/saAboFNDQsgc7RTQPJYarnkM6JlY8uhW0oSNh6o3G9al1zZ07Ma6VE/G4U3wrjiZyyPJYaIGTV/eotNRrQHmIyipUta6cmdDj+GRrNBMWjeZpTz9ZHuIqHlm2Pjc8vJysl4g/x9jJPYOX8zvoLs4ly2CLHwYsCVmOA93mCvHjKLHisfMj1Nq1vjPBYekX8MBS2Tm5SMLHdt3vDcbHwZqdgwbPVSC3LHmPXakvId+chjGcDpXIZUW995JONWbGAcd2/gq3fPupkgNwP9jOOzPNnNsLHb7hqf5dHPLMwPq241P/G/zBtwzPNTcGGZ13djeGYU5BsQiMrondnuzRu+62kD3FD+SC21fWzjH/Abjxcawztb2lMSE++6TreYxnhrOXL6duECH3iEN/VS0Z6U7oOzjvaIeGWEX78DsdbbHfM7WtY+n6/B0siozw+Yf3bogW7fdHnG32f26bPoWejpaJrZd1JJ1I5S64d9ePR1NYo9qzYNePUgM9/PRnH9jaNPRZRwaGb1xoH716gWVlVevHJg38NO2kr6GTuKF1MmtB2IsWu7bK+thtY6PocNRM17CyllT9mqZGHOrbiYBhtFdFFfxKzRQdYqsDTdkA9chq7Fje2TCyiXZsKHfJDxtxslYNjouUqw4MAORoLFxZ0pJEkDzpYTDQNUNwSXzoGaVsqlrUs/xQXGfCYxxmfEU8UT3Yl0xC9R3xAftwPCwvxQdtsPUUKLmcqqMDZwJenpi5qjJKLbZyPluvYHil6wAaBLnYsJC3phZahJG2uqgOOlzc7ICtzEAKCPL8VQSxzPtsJBXZoaahJEycI72G3MpkheFDN+33TOz1GQcS/kLGph2c1Qr+1TRXTDbM1fxtfWYbM5fk/T0tKln7k3RwBsnH7vFMaRS3FfuWHi6rGemPbo7ZtvAybpyC07Tz7Rxuz67ODk5OcfKjz/+qx6absd2yWwb+NEJetBf//Zv//jRkrkuBTR4YnZ9vUfi+4drI2SIkkj/pGW+Knal6JWfP78gbipRdYwEC69++nBQaaXTiURCaoOrhELXk6c96PhhBgAHZElXsHu8uZmpCtD7xW4UvfIX8JG/E2oCvcE+8PDLy9UE4Fa0w0UAeOBhoSvkhUklMJBE+tJqT6Yd2RQ1fdeNold+R5/5LKj69kR46OFqT9QIfKkL7IkZDTKEfmu1JR8R9Tx61dUw9u/Wh/6yorFvm7qS7g0aYAcevFr2uYWcQCJBf7Caks1KXZqGi7pgptDUvvek5160eoUG2NeehrSpcQMjp9NoHOGhW+9RQ6pBAfrk7KYbx4Qwj/5KrlBV7x0LG10HrZ5VDajnZ92Z75FpA9bLL+8/rLbQ+MkwJyqW+7AZYaC/Hu9vHMW68bopM1U044vGjvZer10x0L3bN6QOLLoxnxpYzxfo+15WALY9Z4QSiVWrITUC/fXNzd1YsdjVMnpFwWx7ZchJKcaONvYPKXRIMXnqRcSecGaeJd35Arfq7ObPf/zyyw9EfvkFuyYFAn0jb2O4MtNEhH9ho0niY2JF3L3/+R92A9xl8nw8IMy2huOcvU5s+8A2rnoyvozywmDmk0kSDrIE+rUcC/SsZ45ZgqZzdinV7ZJr6odzFtsIOE1d19i2D9jpKFtKwVQhGDhINtrWX6pBr9CfP78QRMPsBN1D6GhqicE25vU3PoQUzEC2gbLNqJnboSkxmUjQE/Rn0C1//7zihbnP0GBIHmeol3R3zWLbvhgVJV9KpUpt9oI36N/QGPyVpVaNYYOBpg4HlNC95qZzgxvDONniM9UL3qB/te6pUmrluD0oaGK6SNXj6jvuQwJzNit511g2g8FuoIGHveLKPAjokTmq65B6tgaK5sbtbCQYsdMXWakFPUL/Rn2rXyEkXmOMyv15UNB4aEaqVvmjUwYaw1jmYDASFGsRqrVCMOIV+sVn+jlIrR3DBge9bjj26geDHberiBliF9ihPAOI8R8w9P54TMylYbeibeq/6+ZnLOJuHnjszeOhR36gqp5T/PXaYPRMmQF1liq7lo3QywT65PDT671bDpx1Q1c+k/Vxldq2oj/z0OBpt3c3b45P+gA9MkPnatm+p9gxjGG2lV3jLnKrrOrxm5sjG/sFRy0mB6qZmQXH7cb+GptZ9zjoCapqebm1GGLHbQ4P9OH8poAcFJeW7DYWB7PyM0+tYaZdWs6WhdA9MwNtEmg5oDAXatFAjcgHsCPSJTmI8EYTF/yNWSaq+zOjaNKRGek8LvJPBnDjXPEnqmiZWSURqcbsRBdF+O3QldlW9LH42HYy/qg9HjKUKfyTcWrdBU/MQPKi77JHWi6RkUFMy2wHvoVn5rfhtu1joO+doElst+oVGtxXyLNxYJ19U2o9M7Xu1/bjMtmteqOTTD1y29YRmsQ54WrCq8C+ni3UiMpjWlUjx0TPLFl3LbLTbHTKuVwyBeudHsE8Mqt3vwE0jvmBTu0ZmpBjdW/oY4Mrn3/92Z2ZJGDkIXAymUxZS/lHbWlNzThA0zj+6KZ3VWNs7KMf00Sy7nbw6BxdxDmSW2UADBbxJopePG4bzwk6AFT9snsDx4I/ePe4/emxI2wyDWTV0b6UnDpDJ9IVMsq6z1po5s5CQf/G89ea2i3zykwybSLlZP+2ap2gDajqC+ygZJyhrdGriuNl1c1agRSd7T0m54TOV02YOtevXXlnaEj9wYOBA69UU/zOqbr77KIYzp3L9jW7yB26gktOqg7INR3xKFcx3EMeGZ6v2uV+Zhe5QENqsrrUGLgzMp8813XGIF1rNB7peXYHDcay/8RfrGYu6GixHPEBBVdm7u6xW/yUfK6PWZJu0FDV/6WHloNHokjBI2dlS9ESssTa6WOapDt0ooU1rfDAI1luE6AWbO/Ud+s7W+0CcUMPFQUNejdsRZHvTbbkS/07D8QD9CUGk9danGnntyzXGEqZFIZzleGu2lZl9sdwdtFosH/FDB6g8Zwle6Isc7ZeIr5xKpnMkcqVfV2RkqKGQ3MnXWXV+6Zq94GMrC8lRTOb8PldRJyKx5eXYTJsOaM3bpv7Fd3lcCrWsYMI5X5N1W7zdCLxVqNohnkLIsPVAMl7Via49yox4pUF1ZmS66eT5/Pz512kibn43ol0+r2uR5MxbBOo2Vrjoi3r8HQ0h//0sU8VeMTAO4oKU5jrRWTSY1agDho8HC4tqe8t+WM0IFZrdnJwl56u9+yywzOhStqhntbptnEygDfkoWwxwG61z3jTthoaFSccQeZVPIzVBEVT484A5hQ5ugVD01KdQ5Y6dvT6Rj2Y88i3G2zEHPyf5pHJZYcPfDaJYfzQIzQuTTDvLt9+eU9C7OLKkibKIeYouwCajpo0/9umjo0jj/KjVCIvIr+GX7lva5vqGfgnIvREKCCI4Zo4pIaehsVknd0tNjYtWjedrXYsZrYpsAKvblNbTS+SUvmTj0daK48BZPytZ3d4PBinAeAtqQLvVJHGqNi18KTpzo4Uthetm4xiQTCGiU4xrMBjqWOQ5iPzsLWNmKKOGlzb+MTc9RH9NjG637WVk7yTaxX0dU/Q9VFZxF0drOhqAzELHQ3VHbLUxT1x92pNqreNbYgpoCd7xVjskPxvOyf9urJxIxL3wUwBrWAWJ2mS7rvdURV9WsVolPrs7o3ikcfCwP5Jcc+nI2rb2/DX9aBo5V5NL9DVmjhfYfOvlcrKgAZML2OopeRgJJyu+aRuKnQvDelZ+KYpFTJEeSw0DHZlg5IzhuO7sERM6Q8L1ErhggtFVtE1KbFlS8FM9ylE0aYNeYGuZvJZ1eYkdUyqzbJu5YMsPClTM5tdV5ymD+3febvZFAZSJfPIog7addbSQufVvOzYnS3BHq3eYIFHCSp0nY0UaNSBraJnsvcLnU65U2e7hJpZdExs83bJdnWAdopzY0U4FkCqLbwGf0mMzdSTs3nsBbRC7diJear+DGVyANB6ZtKldzvJZX0omhvDN7ctzxQGF8l8t89AMzuTBcAYB2vy3Ywz81NDWwBwknYK1jEW3m7gUMomYyhMQLzIzNEFuGKDBarWiW07OuanhrZ0kG+UnfNdwqiOurSz3ciVy5a5IncW++1f7U4dO2Gh4bakCX6vZGl7q5FM6Q5ge2JoawguoHHM6eFw6QJ0hiJI2ww0Nlx7ycUmGxSQjwd/L/TJuPYo6GeBzrpCo/M/zWUg8dQOA43HBDs6fMNDW8doWp80tRuzTwsdtKHdInXo1FMgZAVirdbkNCQFNCm+125GP595uwbqrMMSzDjWtPVYtWPKQeNzFhzOfX4W6Ly7eRMBXZvp00G5PFGC9vDQZxm90YkUXqHjzOhN5rzhgsZtbrpMWQy0mbI8kk3rAU6bfn6Fxm3eKUOPzEPzgG+GT3omERjVth/OP3tWaP1yg4y+1k65h/YBaHyqD0lnAOsOUQqR54fWLyyDZPStlby1jzk6lS5jIpy0I0Gab/ec0BY5CiHIO3e4U+96O1sHKDppEckpHHx+oS+gUUPlxG7SqYPaIALPHDV3R7kuTR8UzEsnChS8bskOEprtioJ9o0Qn1+1TuMTMCNZNBgeFl9L2+gqSvkKrnESNfQflqLeCmSpa2vlUDeINr4fq9RU61ZZ/f1HV5IfZlfY3JGawqk4Sy3WrfwBf1PScMNZXaNNMlupt3lMU06moT2XFQ50iCcAFJaEf8SFCYVt2u9lBy2dviYF9hbZWssny/pff7bV9UBTSUEUQnmc2iXFLimbKHwrtegMlb+iXz4OFJgv4vcvVi7cfztT2TbXU1oZzRqz+TPwSuUdj685s75ZIKrfD8nmw0NZK1jTvWpXK5SXOfd4UNU33ajUBWsK8TJjl3V66ZVC2gJdxLvdzQJMDA4/S6XSrdYn3TkVf3E45aWMLFxqLgx90q1pOqMXDxj9RgYIZ7TaZu7/QVptxzklLk4rADEPZDklAD9uCwlwmPTRVziwlHs7hxR9xkq/ilXdQ0CS7KI3rlBQeJF0VV3eBeXLYOLJnvzdF6h40kvBl9c/eEiAHBg2zJN9rVM2OvtkGSamyjtCEY8Jy2d6lUPxkZIv74LI11VN62CCh0yT1WbHCZjyqwm4Z5c7B0hIYxUw1mBMTFLniZCD86aKSXuwpY39w0IFEuvLfml4pxH02szs4ObRcara5vyiYSfDk7WolrT2I4tmgE63/we2Tmy45VdVMLZ8X95elPX2ma7y/WG0lPKSJPBu0KoIU0R4NQX8HZaUmGcYgdHrGd9Dpyv/i1iujKBHN0RBEMlIeA98xXgLzTvgMOkHPWNPW1joVcWzqt7nxHVcXlVbCXwMZc5qNQ2FWJJhX7VlUpZAL+xkykv102Ur7a8oCHplrhRJCiGSFyqzNmpygw3+E3P+20vKRcxJgDhB0Lxy3Qny1TKZWyxdQ5aHLB0jM6eyi0tNLcwalaU/GzXJT8XI3GQG/XPZUfjQgTYNRjLzxqcsCak9iG7g65rR++jC5NDk5oUldHww0YO69ktgLNFmdnqG1qYg8GSCnCJ4r0+EGBV0ho9IgmBkDr8unHEywx8SFzhXaHhA0Pdl4EMaNqIk7JxUVzvEZvqqzPgcEvTpI40bQxMB3hNPp50QgY146CXFA0C71tH2AJh7KFg89IfMYkoUPWNNK6q6PhnBgFt5DQBrFs4g1KYPq019Io+QIWbDg7Wwfen9Wut9mruU4aMm4kcwIqh4UtH1GO69ra2nlsJqQkOGaZJPXtr08O+mk2IFsXaVouRBnUM6JhpqePZdxyldgkAlenrndZn53gJIE6RerinACcknK4DyylkzNLSUzBZfODZYizO22cdjMV29X+d0CHU3oKaANdDiASM0fMQg48vrlFFBsQYis5K2bWebLCh8DPtdB8516cKsskVp5HoCcq0DMWsozwMq2xzDILCwtx3XQU08ALR4EAfPyC5oMR8XKM6LKM0CPYZjfvV2ttNL8wnJeB817ZQMNDKb/oG+ezeiPfZA9VX0yZJX28pMDyCzEyJ4fGlDPSu9JBxJpNLnDgGVXlcszqNU7O6OSfD24hMxCNNQH0IHErClRZ+rwNLQSc1l2X9gTE3bLyWSydCg85QrZdiLgQ+jAbNSM89TtUg4d+ZAq14k+5Q1sYsP5rQbagE79cfnhRMXsT2hYbbRtNzYP9Gadh7YcjydxSYpcSo+7dL2Uw3dPtSoH71nmS4vZn9BhjnqrhI/5QwkLcZy+Lo/fONWzhDIV4N0LcI//JSmwtcbthG+hrcoyy8LzzRwuoAnjEg38ilZN1hXNUxgZWQil063KhaVsPG6jL/AntJU9AlW6AzuznQEEr+MsMWH5SfOj7fzRhRD0ayuVl+9g3PeSMvsV2soTSpWlDCBwPaXs1CTU2SAlGRDaSugA2r6oENP2MzSqsQIDF64Zoh4UTAjEvZ13T/Cme5V5f/KCdRo+xOZfVuNbaFptJOQ8gatN5UhmXQyW7XrMBSvYZ72YiH0vkX+hcbGRmPQUpme51Li8dTyObTN1HhhafgOVj6ERt7wPATo1tuRsgRHsmtRzMrQk/oZWSTga59/IwUkpZ58N+E1Bm4qlBJbNXPLbhKalOAqJsGHObwo6mtRC19l3og8TtOFyhAaYvyMa5mqHfSe6b6CdzvfGDw25nIsDnbJDJXOmmWLPQfENtNNJ7uRPLmd8Aeip1sFLhfwfX9rvG+hTPfQS+ZPbYUDh8AN0qGX5c9mMMv6bb6ApmZyqaB+e4vqq0xnrlZeSzHI+q2+g6Xtm5KRUejaQ62FXkCahEGE08Au0E9jCPPmbW8LqvYYmxI8GfoG2N0Wn5D/S7RW3c58WNTTGpB+hZ0kzlIMVPQZK97o46Ubx6/k+4xNoqkvF+4RAI+k+cch51hoq6FP71X/KAdoev50dlGGCnqWfUr4YbWRknXmSU7ceIugp++3hhmIYg8K8BdLpxNnhgb63ny2MssrvdzpxdmiguZODtacls4cXhtQpmsMDPcumODidn8umsRmhJbWNDwX0/Rz3LmatcUuPNkLG0uLp/QIUxjr8C72Omjp7ujgXCHEgLqVgS/yz6XvVmUf7F3oxpHzBunHtcvz5ujrZxxgOaHXbr13XjevKpw8xtDHn5Zj7CUP+7PBCK11uhZzOSB8eVmgj4OWsdyTAxI1uHu1XaMObabPYhsdH+xQaAMxp/G099sS5EaLkQwIdorwh41pX7OTCfTq5ND4zTNDoHmNm/Hxy0XWacgJHTs7C1HB4ZFMLovvYL/Ev9ADlO/R3aO6279DfofnHfYf+Ds3d9h166KG1JUo8dO8vH+mL6LZqxZCjDnqev01bjMZ7z5rqRA+vmemLTOmghd9cwyzuf6uLaqWyw95fKNQf0Rma8PUaFYrxG11vEXrBgrr41sOro/ojS+pmzguLGw2N+NtoXoQlxbY0YdreTjfrXtTdS9oLXVDfNi8+TvPKMzFzUfOtT2TdumZKy/YHVeeXd5VmVU9TaFClag9vg+uXqJoZkkOt64opWNVKxVBmzMiRD0U/MNzzv/on8nkVyr51HxDvU5zlAX4c2XKUeV2SgRtPZ9xQRP9IeQgNaKZAbcwoc4wXBAfF0Hgci3xk2gh4fzVxX4R/Va52K3SWs3DtrtL6ObexOqNT4P24fZ9hXHt4fWl/ZWqJxIcNY1xvZesPAXrbjIPHuDhPb3N8x/LEPNmYnH8aV0yQqcXreeBDjD84d6z10yV42/zkqXOQ8n4Shpvnl9yCt7OLD0tLD4vdxvFZ+X+e4tGCwHiKmQAAAABJRU5ErkJggg==" }

03_Dax.pbitool.json
{ "name": "DAX Studio", "description": "", "path": "C:\\Program Files\\DAX Studio\\DaxStudio.exe", "arguments": "", "iconData": "data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxISEhUTEhMWFhUXGBgXGBcXGBYXHhgaGBcaGB8XGBsYHSgiGB4nHhoYITEhJSkrLi4uGB8zODMsNygtLisBCgoKDg0OGxAQGi8iICYvLi0vLS03NS0tLysvLSswNS0rLS0tLS8tLS0vLS0vLS0tNS0tLS0rNSstLS0tLS0tLf/AABEIAOEA4QMBEQACEQEDEQH/xAAcAAEAAgMBAQEAAAAAAAAAAAAABgcBBAUCAwj/xABTEAABAwICBAYKDgcHAwUAAAABAAIDBBEFIQYSMVEHE0FhcYEUIjJTkZKTobHRFiMzQlJicnOCorKzwdIkNDVUdJTwFSVDwsPh8TbT4ggXRGPj/8QAGgEBAAIDAQAAAAAAAAAAAAAAAAEFAwQGAv/EADURAQABAgIGCAYDAQADAQAAAAABAgMEERITIVFhkQUUMUFScYGxFTIzodHwIiPB4UJT8TT/2gAMAwEAAhEDEQA/ALxQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBB4lla0Xc4NG8kD0oOPWaYYfFfjK2naRtHGsJ6LA3QcSq4VsJYbCoLzuZFKfA7VDfOg4tZw20Tco6eofzkRsHneT5kTk41Zw4yf4VEwDe+UnzNYPShk4tTwxYm++qKeMWPcxuJGW97yPMhk08I4RcUfUx69W5wLu51IQ05GwIawXF7LLYpiq5FM9ksGKqqotVVU9sLt0Y0sjqrMd7XNbNhOTrcrDy9G0edZL+Gqtbe2GHC4yi9GXZO78JEtZuCAgICAgICAgICAgICAgICAgICCu+HGSZlAySGWSPVnZrmN7mXa5j22JaRcaxYepBQFU4vN3kvOWbiXHZvKJeWjI9Xq/FBhEvThmbb0QzqG2zl5cvT0IDG5jMf89CD7Ye8NljdfY9h8DhvXu3OVdM8YY71Olbqp3xPss6WHO4yINwRkQRygjYV0VVMS46iuY2wmOjOmxFoqw8zZvwk3fK2b7bVV4jB5fyo5fhe4TpGJ/jd5/n8p60gi4zBVct2UBAQEBAQEBAQEBAQEFd6b1D21RDXuA1G5BxG/cVdYGmmbW2O+XN9KV1RiMomY2R/rgdlyd8f4zvWtzQp3QrtbX4p5ydlyd8f4zvWmhTug1tfinnJ2XJ3x/jO9aaFO6DW1+KecnZcnfH+M71poU7oNbX4p5y4+lz3yUkoc9xA1XWLie5cDy9a1cZbp1NWUfubd6OvVRiac5nbnHbwlW7iLDLz8/QqN1I123IbOfp5UHnXP9ABBmRx38g9CDA2HqP4figwCiSRu0DnSSEzl0yFu1gcT8Zwb6AVaz0lHdT+/dQU9DTntry8oz/DSm0sldkI429JLvQQsNXSFc9lMe/4bFHRFuO2qZ+35WnwHY3JUQ1Ecj9binsLQL2a14OQB2C7XHrWncuTXOcrG1ZptU6NOeXFZq8MggICAgICAgICAgICCt9O/1s/IZ+KvMB9H1lzPSv8A+j0j/UeW4rRAQEGrisWvDK3exw+qVjvU6VuqOEs2Gr0L1FW6Y91X6pt17xy2XNu0GNz2jdy8uSIebDefB/ug9PIsNuz8TzIJlhvBjiUrQ4RRMa4AgvlbmDYg9prbQhm0tLtCqnDWRPnfE7jHOaBFrHVLQDmXMbtBPJyFBGnvO88noQeRsPV+KDAKJWnwAVGrWVUXw4Wu8nJb/URErzRD4VtXHCx0krgxjRdznGwAQVTpHwsSOJbRMDW7ONkF3HnazY36V+gIIm7TLEpHD9KlLiQAG2bck2AAYBc3yspF5aKUdRFTMbVSmWY9s4m3a394CBmBv5TfksFA66AgICAgICCFaYcIkFG4xRjjpxkWg2aw7nu3/FHXZBU+NaW1VTIZXua0kAWY0AADZ3Vz51noxFyinRpnKGtcwdm7Vp105z6s0Wl1TGQTxMg+DJBCR4WtDvOo193xTzT1Sx4KeULC0R0ww+qc2KemhglOTTqMLHncCR2pO49AJOSa+74p5nVLH/rp5Q+emNOyOpLWNa1uq3JoAGzcFcYKqarWdU5ue6SopovzFMZRlHYlGiWGQPpY3Phjc469y5jSTZ7htIWhi71ym9MRVMdnstOj8Parw9NVVETO3tiN8uucEpjl2PF5NnqWrr7vinm3eqWPBTyh+Tqmn4t8kfLG9zD9BxYsTafEFB6LczZEMlht1nblu3oL+hrpvY8yWKQslZSMIeLEgxNAdtBGxrh1ojvUdimNVNTbsiolltmA5znNB2XDSbA84CJaTrZbdnRylAaRnlyc6DzrdHgCCc8DlZqYtECfdY5Y/qcb/poP0YiFI8LGkb56k0zTaGA2IHvpLZuO/VvqjcQ7eggikWjwRaKaxFdMMgSIGneMjL6QOs7ioFsIPlV1LImOkkcGsYC5zjsAAuSg5mi2kMdfBx0QLQHOYWutdpByvbe0td9JB2EBAQEEN4TtJ3UdOGRG0012tPKxo7p458wBzm/Igq3QrRKTEJD2xZCz3STabnPVbfa47bnZtO0AyLHfo1SUztSKFuQHbOGu485c7P8ABbVmmNHNoYmurTyza9dgdNMLPhYecANI6HNsVkmime2GGm7XT2SrrSrRp1I4OaS6JxsCdrT8F34HlWrct6Pk37N6LkcW5gOJOlaWyOLnttmSSS3kzO7Z4FaYG9p06E9seyi6Uw2rr1kdk/aXZZO8Cwe4DcHEegrdmmme2FZFdUbImWeypO+P8Z3rTQp3QnWV+KecquxtmrUTj47jv7o6/L0rn8RTo3ao4uuwlenYoqndH22Ofrn/AIy9CwthmQ5+D0IMDYer8UF78GbePwIwnPKqi8ZzyPM8IiVDtzR6eyw2GW/blu3ogY3PaPDzcyDzYb0Hf0FqhFiVE/P3aNm73Q8V6HIP1MiH5p0nB7Mqr7eyJvvHKRzEF18GOl0EsEVI8iOaNoY1pyEgaMiw8rrbW7cidigT5BT3C1pZxrzRQu9rYfbiPfPGxnQ3l+N8lB9eBCrIlqIb5OYyQDnaS0n6zfAEFuICAgIKK4XasvxFzSco442AdI4wn6/mCkWfoDh4goKdoFi5gldzukGsb9FwOgBQgxr3U9AW5Y+VX4n53VioY7DtBsHoWvNyrPtbcWaMuxztJsDimpJ4wwXMbi07nNGs0+MAomuqdky9U26KZziFEYBJadnPcHrF/SAtjB1ZXo4tXpKiKsNVwyn7rv0VwankpY3yRNc469yRmbPcPQsuLv3KLsxTVlGz2a3R+Fs3MPTVVTEzt95db2O0neGeBa/Wr3ilu9Rw/ghQXCzhjIMUlawBrXsjeGgZC7OLy62E9ZWGqqapzntbNFFNFMU0xlEIXlvPg/3Xl6enEZZHZv6tyA123IbOfeEF1cAtTelqIz72cOtzPjaPSwoiVP4zCY6iaPPtJZGeK8j8ES0xsPSPxQGnMIlgjkQbFNMYnxy2Ptb2v8Rwf+CIfr1puLhEPz5wkUvF4lUDkc5rx9NjSfraykRpAB5ev/dBKo+EPERDxPHA5W4wtBkA5nb+cgnnQRUlBZfAhSkzVEtsmsYy/O9xdb6g8IUC3kBAQEFF8L9IWYgX2yljY4HoBYR9UeEKRZnB/iLZ6CAg3LGCJ3M6MaufSLO+kFCHrGvdT0Bblj5FfifnYbikoFrjwBTqaURiK4aeM47IyCRxI7kgZDaRYecrxXaoppzZLd65VVEKgwuC9S22wXcfBb0kKcFTnejhtR0lXFOGq45R91gYfpJUQxiOMt1W3tdt9pJ29JVpcwlu5VpVdqis4+9aoiijLKODZ9mNX8JniD1rx1CzxZfiuI3xyVrwnVz56mKaS2txepcC2THl3+dV+MsU2qo0e9b9G4qu/RVp9sShxYdy01iyWGw69w3IDG57Ry+hBaPAJUWnqo791HG+3yHOaT9cIiUQ4SKcR4nVtttk1/Ha1+74yJhHWu25DZz70HnW6PAEHp7zfaf+c0HhzbtI/rMFB+sdFKvjqKll+HBE7rLAT50QprhVrGS4jJqG+o1kbj8ZtyR1Xt0gqREEBAQfSngdI5rGNLnuNmtaLkk8gCD9CaC6Pdg0jYnW4xx15SPhutkDygABvVflUCQoCAgIIhwlaMGtpw6MXnhu5g+ED3UfXYEc7RvQVNofpTLh8pIaXRuNpYjlmMri/cvGY59h5LSLZodJ8Mq7O45jXEZtldxThzWJAPSCQvVNyqmMoYqrNFU5zD6V2KYbELulYeZjy8nqaT51611e956vb3K40q0hbOe0bxcTdjSSST8J2e3mGxeaq6qu17otU0fLDtcFmEUVSyV0h159bNms9hZGMhaxGtc5k8mQ6fVu9XanOicni/hrd+Ii5GeXGY9k89iNF3o+Ul/Ms3Xr/i+0fhrfC8L4fvP5PYjRd6PlJfzJ16/4vtH4PheF8P3n8qz4cMBhp4aaWFpbeV0bu2e6+swuHdE/AKw3b9d3LTnPJs4fC2rGerjLPjM+8qjkOf8AXKsTYYGzrH4oDDmESmXBNisdLiGvNII43QyMLnZC92uHnbbrREp/jGkejr5XTTMjnlNgXGCR99UADu26uyyIU9jL4X1MzoAGwukeY22DdVriSG6rcmgXtbmRLn2G/wAA9aD062W3Z0c34IDSLHL070F66L6UCnwGneCONtJDGNxZI9oNtzWgHwDlREqvmpXEk3JJNyTmSTtJPKVI+Jp3bkE4wngqrJWh0r44ARfVN3vHS0WA8ZQJDRcEEA92qZH8zGtj9OsgmWA6LUlH7hCGu2F5u555tZ2YHMLBB2UBAQEBAQQ/S7g/p60mRp4mc7XtFw/5bcr9IIPObIK5r+DDEYz2jI5RyFkjR4RJq286ke8P4OcUcbOYyIb3yMP3esUEjquCf9Gdqzl9TtBI1Yzb3mrmRf4VzsGW0KBWkUlRRz3GtDPE624tO4jY4EdIIPKCpF4aDaaxV7NV1mVDRd8fI4fDjvtbvG0cvITAlaCv+HGmDsLc4j3OWJ/RrO4r/UQfnxxGWXJv6vwRI123If0edB51z/xl6EGZHG+3+igxydf9ehAZtHSiWLIPZYbDL+tv4ohmKMk2G05Abbk7Bkgm9BSujhZE5xOrrG3IC86zrdfoUoe3RIhN+DXRkSP7Klb2jD7WD754990N5Of5KJWioBAQEBAQEBAQEHAm0vpWuc0l92ktPanaDYrcjA3ZiJjJX1dJ2KappmZ2bOx49mdJvf4hU9QvcHn4rh988j2Z0m9/iFOoXuB8Vw++eSNaY/2biABc6SOVuQlbHc6vwXD3w3bj1guoXuB8Vw++eSMUujVLE9skdfMx7TdrmwWIO8dunUL3A+K4ffPJY9NpjThjQ97nOAALhGW6x36tzbwp1C9wPiuH3zyc7SrGKOupZaVz3tEgA1uL1tUtcHA2vnYtCdQvcD4rh988lcHQGh/fpv5cfnTqF7gn4th988gaA0P79N/Lj86dQvcD4th988mPYBQ/v038uPzp1C9wPi2H3zyZ9gVD+/Tfy4/OnUL3A+LYffPJkaB0P77L/L//AKJ1C9wPi2H3zyPYHQ/v0v8ALN/OnUL3A+LYffPIdoJRH/5838uPzp1C9wPi2H48nn2A0P79N/Lj86dQvcD4th988m3hmhtBC/X7MlcQMrwbCeXJ/wDV06he4HxXD755Ox/ZlHy1Mnkf/NOo3uCPiuH3zyY/sqi/eZfI/wDknUL3A+K4ffPJauGxsbFGIhZga3VHNbLrWnVExOUrCmqKoiY72yoehAQEBAQEBAQEFOYkfbpfnJPtldLa+Snyj2cZej+yvzn3lray9seTBcicmOMUGRxiGTIepMmdZDI1kMmNdQZMcYhkzrKTJnWQyY10MmdZDJjWQyNdQZM6ykyYLkRkuPCvcIvm2fZC5u789XnLsrH06fKPZtLGyiAgICAgICAgIKYxN3t03zsn2yultfJT5R7OOvR/ZV5z7y1tZe3jJ1dEaWOaqbHK3WaWuNjfkHMtTF3KqLedM7W7gLVNy9lVGcZSsD2JUXeG+F/rVV1q94l71Kx4IY9iNF3hvhf6061e8R1Kx4Yc3EtAoHA8Q50TuS5L29Ycb+ArNbx9yJ/lta13ou1VH8Nk84QCsp3wyOilFntNjuO4g8oKtrdyK6dKlR3bNVuqaao2vk969yxRCc6E6OwTUolnjDy9zi0kuFmg6tsjvBPWqnFYmum5o0zkvsDg7dVrSrpzmXe9iVF3hvhf61rdaveJudSseCFf6XUDaeqcxg1WFrXtGeQIsdvxmu8KtsJdm5biZ7VFjrEWr0xT2drlwVDWPa57NdgI1mn3zeUdNtnPZZrkTNMxE5S1rUxTVE1RnG5ZbtFqKaHWhYBrsux4Lja4uHZnzKmjFXqKv5T2dzopwWHuUfxjtjZKs5WOY5zHizmEtcNxBsrqiuKoiYc5XbmiqaZ7YdbRHCeyqizh7Uwa0nPuZ1nzArWxd/V0bO2W3gcNrrm3sjt/CR6YYfRUkF2wt4x51Y83ZHldt5Bn023rTwt29crymrZ3rHG2bFm3nFMZzsj94II1yt4UEwyXKUZLmwn3CL5tn2Qubu/PV5y7Cz9Onyj2baxsogICAgICAgICClMUPt83zsn2yultfJT5R7OQu/Uq8595at17eMnd0AP6cz5D/srRx30uSx6N+tHlKRcK0jm08Oq5zbzDuSR/hv3LRwURNc57ll0jVMW4y3/5KvYqiUZiWQHeHvHoKttVTPdCj11cT8085T/g80ilmc+nncXua3XY87S0EAtceW1xY7czuVZjMPFH8qVxgMVVczornOXx4UqQDiJxtuYid+Rc3wWf4V76Pr2zT6sfSluMqa/RAp5MlaSpohdmGwCmpWNdkIohrH5LbuPhuVztczXXM75dXbpi3biN0IDwX4m51VO15N5mmXM++a+5A8ofFW7jLcRREx3bFdgL01XKonv2/vN0OFKltxEw3ujPWNZvod4VPR9e2afVHStGymv0QV2YVqpYTfgyxvuqR53vivu2uZ/mHS7cqnHWcp049V50bfzjVz6fhjhNwcgtqo2k3syQDPM5Md6G+KpwV/L+E+iOkcNnlcpjhP8An4SjRPBxSUzWutrnt5D8YjZfcBYdV+VamIu62vPu7m7hbEWbcR396s9J8Z7LqXPB9rb2kY+KPffSOfRYcitsLZ1dGXf3qPG39bczjs7v3i0AVttIJRC6sI9wh+bZ9kLm7vz1ecuvs/Tp8obaxsggICAgICAgICCkMVd7fN87J9srpbXyU+Uezkrsf2Vec+8tXWXtjyd7g+P6ez5D/srRx30uSx6N+tHlKR8LP6vD8+Pu5Fp4D6k+X+wsOkvpx5/5KvGHJXMOflIeD136eznY8eYH8FpY/wCl6rHo363pKUcKf6ozmmZ9l60cD9X0WHSMZ2fVAdG6Xjqunj5DIHHoZ258zbdassRXo25lU4W3p3aY4+21Z+n1ZxVDLveBGPpmx+rrKpwlOldjmu8bXo2auOzmrHRWr4mtp33sNcMPRINTPxgepWuJo0rUwpsJXo3qZ/dqztPqTjKGW21lpB9A3P1dZVeEq0bsclxjqNKxVw28lSscr6HNTDDZ3RPbJGbPYQ5p5x6RyEbljuURVGUstqqaaomO5d2EVzamCObVsHtDtVw2Hby7c9h6Cufrp0Kpp3Oot1xXRFW9HeEvF3Q07YWXDpyWl25gtrC+83A6C5bOCtRXXnPc1Mfdmi3ox3qziFgruIc9L3rKXnILkMl24P7hD82z7IXN3fnq85dbZ+nT5Q3FjZBAQEBAQEBAQEFGYsfb5vnZPtuXS2vkp8o9nKXY/sq8595ausvbHk7/AAeH9PZ8h/2Vo476XJYdHfW9JSThbP6PD8+Pu5Fp4D6k+X4b/SP048/8lXLHZK5hQzCV8GUBfWOfbKOI3PO4gAeAO8C0OkKsrcRxWXRtH9kzuh3OFqe1NCzldMD1NY/8SFq4CP5zPBudIz/XEcf8lxeCmk16mSU7I4w0dMh9TXeFZ8fXlRFO9r9G0Z1zVuj3/wDiaaYaOurmRsE3FBjtc9pr6xsWj3zbWufCtGxe1UzOWawxNjXUxGeSLO4L38lYARmDxByO/wB1W1OPz/8AH7/8acdG5Tnpfb/qw5oA9jmPzDmlrue4sclXxOU5ws5jOMpUM5hY5zHd0xzmnpabHzhdJRVpRm5SunRmYnudDRvCDWVDYs9QdtIdzAdl952DpvyLDib2roz7+5sYWxra8u7vWvpDjcNBC17x2us1jWt257hzNBPUqS3bquVZQv7t2m1TnLzpHhTK2lLAQSQHxP2gOtdpvuINjzOK9Wbk2q8+bziLMXrejyUzm0lrgQ5pLSDtBBsQetdBTMTGcOaqpmJyl61l6eMguQyXjg36vD82z7IXN3fnq85dXZ+nT5Q3FjZBAQEBAQEBAQEFE4uf0ib52T7bl0tr5KfKPZy12P7KvOfdqay9saQ8HR/vBnyJPsrRx30uSw6P+t6SsHTLRw10TIxII9STXuW69+1c21tYfC8yrLF7VVZ5ZrXEWNdTo55IxHwYu99V5c0Wfnfktz4jup+//GjHRm3bV9v+plgGBw0cepFfPNz3Zlx3k/hsC0bt6q7VnUsLNmm1TlSq/hBx5tVUARm8UILWkbHOJ7Zw3jIAdBPKrTB2ZoozntlU429FyvKOyEx4KqPUozIdssjnD5LbMA8LXHrWljqs7mW5vYCjK1nvn/jl6UadVMNVJDAIixlm3c1xJdqgnMOHKbdSzYfB010RVVntYcRja6Lk005bHLPCLXboPEf/ANxZuoW+P76MHxG7w/fVO9B8ddWU3GSaoka9zHhoIGWYsCSe5LeXbdV2ItaqvKOxZ4a9raNKe1W2n1NxNdMOR+rIPpDP6wcrXCV52o4bFRjbejenjtWLoJgPYlONcWlks+Tm3M+iD4S5VmKvayvZ2R2LXCWNVRt7Z7fwrnTvGuzKk6pvFFdjNxN+2f1kC3M0KxwtjQo29sqzGX9Zc2dkJbwW47rxmkee2jGtHfljv3P0SfARuWnjbOjVpx3+7dwF/Sp0J7vZzuE3BOLkFUwdrIQ2S3I+2TusC3SBvWfAXs41c+jX6RsZTrI7+1Cw5WaryC5EL2wb9Xh+aj+wFzd356vOXU2vkp8obixsggICAgICAgICChcYP6RP87L9ty6W18lPlHs5e79Srzn3al17eMm1hOKSUsomiDS8AgawJGYtsBHpWK9ai5ToyzWbs2qtKl3TwkV/wafxH/8AcWn8Pt8f30bnxC5uj99T/wByK/4MHiP/ADqeoW+P76HxC5w/fVycW0mrKoFssx1DtYwBjTzG2bhzElZreFt0bYhgu4q5c2TLlBmS2MmtmkmG6c1cETIY2w6jAGi7Hk5cps8XK1K8FRXVNU57f3c3beOuUUxTGWz93uDPM6R75H909znu6XG59K26KYpiIhp11TVMzPe8Er08OngGkdRRa4h1CH2JDw52bb5izhbb5gta9hqbuWk2rGJrtZ6PeziOkk088VRIyEvitqgNdqmxLhrDWubE3GYUUYamiiaImcpTXiaq64rmIzj93uhWaf1ssb4zxTQ9paXMa8OAOR1SXmx51jpwNumYnb++jLXj7tVMxs/fVGWNst2IaEvvQVj4JWTRGz2G4vsPIQRyggkHpWO5biumaZZLVybdUVQ7tfp1VzxvilZAWPFj2j79I7fIg2IO8LXt4KiiqKomdn7ubVzG110zTMRlP7vR0FbrQCVJkvnBf1eH5qP7AXNXfnq85dPa+SnyhurGyCAgICAgICAgIKJxeim7ImIikI42Qghjz793MuitV06FO2OyPZzd23VrKtk9s93Fqdgzd6l8m/1LJrKN8c3jV1+GeUnYM3epfJv9SadG+OZq6/DPKTsGbvMvk3+pNOjfHM1dfhnlJ2DN3mXyb/UmnRvjmauvwzyk7Bm7zL5N/qTTo3xzNXX4Z5Sdgzd6l8m/1Jp0b45mrr8M8pOwZu8y+Tf6k06N8czV1+GeUnYM3epfJv8AUmnRvjmauvwzyk7Bm71L5N/qTWUb45mrr8M8pOwZu8y+Tf6k06N8czV1+GeUnYM3eZfJv9SadG+OZq6/DPKTsGbvMvk3+pNOjfHM1dfhnlJ2DN3qXyb/AFJrKN8czV1+GeUnYM3epfJv9SadG+OZq6/DPKTsGbvMvk3+pNOjfHM1dfhnlJ2DN3qXyb/Umso3xzNXX4Z5SGhm7zL5N/qTWUb45mrr8M8pXrgwIp4QcjxUeX0Aucu/PPnLpLfyR5Q3F4exAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQfOeZrGue42a0FzieQAXJ8CCoMP0nx3GXSSYbxNJStcWtklALnWsbG7X3NiD2rbC9rnag6DcG0rYbivpJPiuaB6IB6UHcxxuPalP2K6l1+KHZHGXtxuV9TLudqCG6TaS6R0HEid1H7fIImajSe2Ntt7WGaDucXpX8Kg+t6kG/ptpZVUdXhVOzi7VUrY5rtv/iQtOobi3du8yCfIIRwu6U1GG0TJ6bU13TtjOu0uGqWSO2AjO7Qgk2K1jo6SWZttdsL3i4uNZsZcMulBVui+OaS19O2pgdRcW4uA12lp7VxabgA8oQbGKaRaS4e0z1NNTVEDM5OKvdreU5G4HxtUgbSgsDQ/SaHEaZtTBexu1zTtY8Wux1ukHnBB5UHAwXSyolx2rw92pxEMIkZZpDtYiDab5j2x3JuQb/CNprHhVMJXN15XnVijvbWNrlxPI1o29IHLdBEKOk0rqmiY1NPSBwuISxtxuuDG8joLrjlF0Hwdpri+ETxR4y2OamkOr2RE3MHf2oaDYZlpaCRsOVkFvseCAQQQRcEZgg8oQekBAQEBAQEBAQEBBp4zRmanmhBsZI3xg7tdpbfzoKc4LNOoMMidhuJB9NLFI6xcxxHbEGztUEg3v23ckEG6C3sJx2lqhenqIpbbeLe1xHSAbjrQdFBVvDj3WGfxjf8AKgtJBU/C9+1MC/ih9/ToLYQVZ/6jP2ZF/FR/dTIJ3j/7Pn/hpPuigi/AT+x4flzfeuQT9zQQQRcHIg8qCoeBNnY9di1G33OObtG7g2SRnnbqeKEH30Z/6sxH+FHopEHx09b2RpJhlO/NjGCUD4wdI/8A0mILeQQnhloGzYRU6wzYGyNO4seMx9HWHWUG7wXVZlwmjc7bxQZ5MmMeZqCUoCAgICAgICAgICAg52MYDS1YAqaeKW2zXY1xHySRdvUgq/hD4L6OmpZa2gMlNNADKNSR9jY52LiXMNr21SN1twT7g7xeSsw2lqJTeR7LPOXbOY4sLsshfVv1oIhw491hn8Y3/KgtJBU/C+f70wP+J/1qdBbCCq//AFGH+7Iv4qP7qZBPMf8A2fP/AA0n3RQRfgJ/Y8Py5vvXILAQVBwLS8fiOL1Tc43zDVdyODpJXCx5e1DfCEH30Z/6sxH+FHopEHx0yfxWlGGyuya+IRg73OM7LeF7fCgt5BD+FypEeEVhJtdgYOcve1tvOg98E8BZhFGDtMet1Pc548xCCWoCAgICAgICAgICDxM4hpIFyAbDebbEFXy8IONRZS4FK4//AFOe4fUY9BysexbHMZiNHHhrqOKQgSyTF7e1BBtd7WnVyzDWuJ2b0FraN4OyjpYaZhu2JgbfZrEbXW5Lm560EO4XcGqKk0HEROk4upa9+qO5aNXMoLDQQXhX0MkxGCN1M4Nqad+vESdW97Xbre9N2tIO9tsr3AR6DhCxuBojqcEmmlaM5IhJqu5+0je2++zrcwQaVTg+LY9UQGupuw6GJweY3Eh794IPbFxHa3IaGgnaciFr6QwufSVDGC7nQytaByksIAHWgqTQjFcZw6kZStweSQMLzrl+rfWcXbLHeg3sZxfSPEGGmhw8UbZBqvlc8XDTkbOJGrle9mk55WQTrg/0SjwukbTtOs8kvlfs1nkAEgcgAAAHNvJQRvAMEqWaSV1U6Jwgkpw1kh7lzrU2Q8R3ilB0eFPQl2JQxvgeI6qncXwuJIvexLbjuTdrSDyFvOSgjdNp/jlO0RVWCzTSNFjJDr2dzni2PbffY25gg0MToMZx98UdRTmgoWuD3h2T3Wy2OAc51r27UNF7m+SC5KSmZFGyOMBrGNaxrRyNaLADoAQfZAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEH//Z" }

Wednesday, July 15, 2020

Power Query - Sum the Max Value by ID

.SaldoBancoMaxID =
VAR vMaxID = MAX(FAT_FluxoCaixa_Oficial[Id])
VAR vSaldo = CALCULATE(SUM(FAT_FluxoCaixa_Oficial[SaldoBanco]),FAT_FluxoCaixa_Oficial[Id]=vMaxID)
RETURN
vSaldo


.SaldoBanco = SUMX(VALUES(FAT_FluxoCaixa_Oficial[CdBanco]),[.SaldoBancoMaxID])

Thursday, July 9, 2020

Power Query - Rename Column by position

#"Renamed columns" = Table.RenameColumns(#"Promoted headers", {{Table.ColumnNames(#"Promoted headers"){0}, "Date_Price"}}),

Power BI APP - Delete or Unpublish

 UNPUBLISH DELETE