adding new column from SSAS model

Question

Hello all,I have a Power BI report which is getting data from one SSAS module. SSAS module is connected via 'Import' option.Now I need to create new visuals that require new columns to be added to this SSAS model. After adding the required columns from this model, when I apply changes, it fetches all the rows and it is taking a lot of time. (There are quite many rows). Getting error as increase memory of the server where SSAS is deployed.Is there any option to limit these rows or&nbsp; any way to add required columns, make&nbsp; visuals, Publish and then refresh the report after deploying.Please guide.

smearp · Accepted Answer

This is because the SSAS data import feature can generate inefficient MDX when importing. A workaround is to write your own custom query, preferably using DAX.&nbsp;Once you do this, I promise you'll never go back 🙂&nbsp;Here's an example query you can tweak:DEFINE&nbsp;&nbsp;&nbsp;&nbsp;VAR&nbsp;vFilter1&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;ALL&nbsp;(&nbsp;DimProduct[Color]&nbsp;),&nbsp;[Color]&nbsp;IN&nbsp;{&nbsp;"Red",&nbsp;"Blue"&nbsp;}&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;VAR&nbsp;vFilter2&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL&nbsp;(&nbsp;DimGeography[CountryRegionName]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[CountryRegionName]&nbsp;=&nbsp;"United&nbsp;States"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)EVALUATESUMMARIZECOLUMNS&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;DimProduct[Color],&nbsp;&nbsp;&nbsp;&nbsp;DimProduct[Size],&nbsp;&nbsp;&nbsp;&nbsp;DimDate[CalendarYear],&nbsp;&nbsp;&nbsp;&nbsp;vFilter1,&nbsp;&nbsp;&nbsp;&nbsp;vFilter2,&nbsp;&nbsp;&nbsp;&nbsp;"Total&nbsp;Sales",&nbsp;SUM&nbsp;(&nbsp;FactInternetSales[Sales&nbsp;Amount]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"Distinct&nbsp;Customers",&nbsp;DISTINCTCOUNT&nbsp;(&nbsp;FactInternetSales[CustomerKey]&nbsp;))

Forum Discussion

adding new column from SSAS model

2 Replies

Related content

Adding columns

Adding a column

Adding a Calculated Column in Semantic Model

New column added to Lakehouse table, not appearing in Semantic Model

Direct Lake Model - Calculated Column/Tables