Edit: This feature has been deprecated since 1st March 2019 unfortunately: https://azure.microsoft.com/en-us/updates/azure-analysis-services-web-designer-to-be-discontinued/ – Microsoft is working on replacement of the functionality to move pbix-files to SSAS-instances, but no solution yet. In (…) Read more
Posts Tagged ‘SSAS’
Guide for switching Signs in Power BI and Power Pivot (bypassing Unary Operators in DAX)
In finance & accounting, you very rarely report the figures with the signs of their source systems, but switch (certain) signs according to different needs. Instead of using unary operators (…) Read more
Visualize dependencies between your DAX measures: DAX-VizArt-Wizard
This DAX-VizArt-Wizard vizualizes dependencies between your DAX measures, shows the definition of all related measures and shows differences between the measures of 2 models/versions. This works for Power Pivot, Power BI (…) Read more
Perfect Analysis Services (SSAS) reports in Excel using Power Query
Excel-reports on SSAS cubes (multidimensional and tabular) can have some flaws that now can be overcome by using Power Query for sourcing your cubedata: filter your cube by complete Excel-tables without loading them to the model/cube (…) Read more
Is it time to remove detail fields from our cubes?
During my evaluation of Power Query as a reporting engine I wondered why we should keep detail fields in our cube at all if the preferred output is a flat (…) Read more